Microsoft KB Archive/121833

= ACC2: ORA-00942 Error Opening Attached ORACLE Table =

Article ID: 121833

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q121833



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.

When you try to open the second table, Microsoft Access will try to open the table using the first account's login information.



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.

Additional query words: attaching

Keywords: kberrmsg kbinterop kbprb KB121833

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.