can't link to sql server

[mike]

Hi. I created a system dsn obdc data source but, when i
try to use link table manager in access, i can only see
some of the sql server database tables and views, not all
of them. any thoughts? thanks!!

 

[Mark Hyland]

Hi Mike,

Have you checked what permissions the user has, that you created the DSN
with. If you log on with a username and password that only has certain
permissions, you might only see certain objects.

Regards

Mark

This information is provided "as is" and expresses no warranties or confers
no rights.