Linking Access tables from Oracle

From: s <s_at_yahoo.com>
Date: Tue, 06 Jul 1999 16:23:21 -0700
Message-ID: <37828FE9.E27C4F12@yahoo.com>

We have a user trying to link tables existing in an Oracle Database to a new Access Database.
Using Personal Oracle 8.0.5 and Access 97.

When doing so, she goes to the Access, selects to create an Access Database, selects to get external data, connects via the ODBC connection, the Oracle Tables available appear, she selects a particular table and then receives the following error message:

Microsoft Jet database engine could not find the object <Owner.Tablename>.
Make sure the object exists and that you spell its name and path name correctly.

The problem is, the table DOES exist.....they were imported from an existing Access Database to Oracle.
Plus, when doing a describe in Oracle, the table is there.

Any suggestions as to why this would work?

Thanks Received on Tue Jul 06 1999 - 18:23:21 CDT