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

Oracle ODBC driver not able to load all oracle tables in Microsoft access 2007

P: 3
Hi,

Oracle ODBC driver is not able load all the oracle tables in MS access 2007.

We are not able to view some of the tables. we have provided all access from oracle side. Please let us know if any settings we need to change in MS access or registry?

Please let us know.

Thanks,
Fairoose
Jul 17 '14 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 1,243
Hi Fairoose. Welcome to Bytes.com.

Have you refreshed the links? You can do that either by deleting them and linking them again, or by right-clicking on a table link and going to the linked table manager to refresh the links.

Is this a new install or a change to what was previously working?

Jim
Jul 17 '14 #2

P: 3
Hi,

Below are the steps,

Open Microsoft access 2007->Go to external data->import ODBC database->it will ask for database usercredentials-> After providing that it will load all the tables from database to ms access.

Here we are not able to see some of the tables.

We have given select any privlage to the user in database.



What will be the reason?

Thanks,
Fairoose
Jul 17 '14 #3

P: 3
Hi,

I am newly loading the tables. i tried in different machine. but still same problem.

its new install.

Thanks,
Fairoose
Jul 17 '14 #4

zmbd
Expert Mod 5K+
P: 5,397
1) Most likely you have not set the user rights correctly and/or the reference to the table schema isn't right. If the tables belong to another user, the the user that is loging in via access may not be able to link to them.

-- You will have to be very specfic as to how you provided the user credential.

-- You need use SQL*Plus to atleast check that from the oracle side you have the credential set correctly.

2) You need to ensure that the correct vestion of the ODBC driver is installed. Older versions of the driver will not work well with the newer versions of Oracle.

What version of Oracle are you using?
Aug 5 '14 #5

Post your reply

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