By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

ODBC connection to Oracle tables in VBA

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.