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

Retrieve Oracle tables in MS Access

P: 1
I am trying to link oracle table in MS Access. Under ODBC, I have defined the system DSN.

Through access, when I try to link to a table (File, Get External Data, Link Tables) after supplying user name, password and server (username/password@server), it shows only one table (_ALL_INSTANTIATION_DDL) and when I double click the table, the MS access generated error "There are several Tables with that name. Please specify owner in the format 'owner.table'.

Now I am stuck here. I don't know why it is not showing the complete list of table.

Mar 11 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.