ACC2: ORA-00942 Error Opening Attached ORACLE Table

• Microsoft Access version 2.0

SYMPTOMS

When you attach an ORACLE table using one login ID and password, and then attach a second ORACLE table using a different login ID and password, you may receive the following error messages when you try to open the second attached ORACLE table:

• Couldn't execute query; couldn't find linked table
• [Page Ahead][ODBC Oracle Driver][Oracle OCI]ORA-00942: table or view does not exist.[#942]
• Can't open table in Datasheet view

CAUSE

This behavior is caused by the way the Microsoft Jet database engine shares connections to remote databases. You will receive the error messages stated above under the following conditions:

1. You have two user accounts set up on the ORACLE server. The first account does not have select rights granted on at least one of the tables created by the second user account.

2. You attach and open any table using the first user account.

3. Using the second user account, you close the first table and attach a table that is not accessible by the first user account.

RESOLUTION

Create another ODBC data source for the same server and database. When you attach the second table, select this new data source. Choosing the new data source will create a separate connection to the same server, preventing the Microsoft Jet database engine from sharing the connection.

STATUS

This behavior is by design. Changes to this behavior are being reviewed and will be considered for inclusion in a future release of Microsoft Access.

MORE INFORMATION

ORACLE is manufactured by Oracle Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.