Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

INFORMATION_SCHEMA.CHECK_CONSTRAINTS

INFORMATION_SCHEMA.COLUMNS

INFORMATION_SCHEMA.DOMAINS

etc.....

and a whole bunch of

sys.all_columns

sys.all_objects

sys.all_parameters 

etc...

the only tables that i really need are tables such as

dbo.users

dbo.stats

dbo.customers

etc...

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
2  
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. –  JuanVelez Jun 11 '12 at 18:33
2  
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! –  JuanVelez Jun 11 '12 at 19:07
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.