can't link to sql server

  • Thread starter Thread starter mike
  • Start date Start date
M

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!!
 
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.
 
Back
Top