Link to Oracle Database using ODBC - Table Name Problem

R

ras

Using ODBC I am able to link to Oracle database. The table name in
Oracle is ITEMS. When I do the link the user name is added to the
Name. Now the table name in Access is PPS_ITEMS. The problem is that
if I need to move this Access program and connect to another database
the table name might be come STEVE_ITEMS and because of this change in
name none of the queries would work.

Ideally the linked table name would be ITEMS but the link would need
to connect to the Oracle table regardless of the user name involved.

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Access and Oracle Database 2
Can't get real oracle error with Access error 3155 0
Access 2007 ODBC for Oracle linked table issue 0
Linking to Oracle 2
Field Values When Linking to an Oracle Table 1
Access Oracle ODBC 2
Oracle to Access 1
oracle fields exceed 255 3

Top