Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was finally able to create my ODBC connection but now when I go to External Data > ODBC > LINK TABLES using my ODBC connection in Access 2007 I get a huge list of tables such as





and a whole bunch of





the only tables that i really need are tables such as





but none of those tables are on the list of table that I am able to choose from to link.

Does anyone know why I can't see or link to the DBO tables I need?

(by the way i created a new user login in order to create my ODBC connection)

share|improve this question
Does the user have select permissions on those tables? – Jimbo Jun 11 '12 at 18:28
I'm going to check that now. I just logged in to the account using SSMS and noticed that I did not see any of the tables so it seems to be an issue with the creation of the new account and not an ODBC connection. Thanks for helping me realize that. I will post back with what I find. – PokerPlayer23 Jun 11 '12 at 18:33
Sounds like no permissions on the dbo schema. – Thomas Stringer Jun 11 '12 at 18:34
I added the select permissions to the user for the tables i needed and now it works perfectly. It was a permissions issue. THANK YOU both! – PokerPlayer23 Jun 11 '12 at 19:07
up vote 1 down vote accepted

Thanks to Jimbo and Shark's comments I was able to fix my problem by adjusting the permission for the tables I wanted to see. I did not have SELECT permission on the tables so I was not able to see them. Once I added the SELECT permission to the tables I was then able to see my data perfectly.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.