ODBC connection to Oracle tables in VBA

[Nolan]

I've written a module to create an ODBC link to a large number of
Oracle tables in an Access database. It works fine when the table
appears in only one schema in the database. However, when a table
appears in more than one schema, I get an error message, "There are
several tables with that name. Please specify owner in the format
'owner.table'."

When I modify my code to do just that, use the format 'owner.table' I
get the error message "'owner.table' is not a valid name. Make sure
that it does not include invalid characters or punctuation and that it
is not too long."

I've also tried 'owner_table' since Access uses that syntax to name a
table when there are multiple versions of a table in different schemas.
That doen't work either.

Any ideas on how I can tell Access exactly which table I'm trying to
connect?

TIA,
NM

[Randy Harris]

"Nolan" <NM***********@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I've written a module to create an ODBC link to a large number of
Oracle tables in an Access database. It works fine when the table
appears in only one schema in the database. However, when a table
appears in more than one schema, I get an error message, "There are
several tables with that name. Please specify owner in the format
'owner.table'."

When I modify my code to do just that, use the format 'owner.table' I
get the error message "'owner.table' is not a valid name. Make sure
that it does not include invalid characters or punctuation and that it
is not too long."

I've also tried 'owner_table' since Access uses that syntax to name a
table when there are multiple versions of a table in different schemas.
That doen't work either.

Any ideas on how I can tell Access exactly which table I'm trying to
connect?

TIA,
NM

Use [owner.table]
--
Randy Harris
(tech at promail dot com)