Link to home
Start Free TrialLog in
Avatar of havette
havetteFlag for United States of America

asked on

Linking a SQL server table to access

Hey everyone,

I'm trying to link a table from SQL server 2005 to access.
The problem is that when I want to "link ODBC database", and create a .dsn to access the database on the server, then when I'm ask to choose what I want to link, I don't have access to the tables, but only the views.

Does anyone have an idea why ?
Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of itby
itby

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of havette

ASKER

Thanks, it was indeed a problem with permissions