Link to Oracle Database using ODBC - Table Name Problem

  • Thread starter Thread starter ras
  • Start date Start date
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
 
Back
Top