Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MS Access ODBC error w/10g Express

21668Sep 5 2006 — edited Oct 18 2007

I've created the new Oracle tables and migrated the data using OMW. Were using a MS Access as the front end. When I link the tables in Access, they link initially, but when I reopen the Access database and open the Oracle link tables, I get the following error:

MS Access error: Could not execute query; could not find linked table. [Oracle][ODBC][Ora] Ora-00942: table/view does not exist(#942).

I know the Oracle 10g Express database is open, because I can view them in Oracle web object browser.

What ODBC driver should I be using with Access? Any suggestions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2007

Added on Sep 5 2006

#database-and-application-migrations

5 comments

11,410 views