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

Re-name the linked tables.

MH

"ras" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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