Can you link MS-SQL views??

  • Thread starter Thread starter Lynn Pennington
  • Start date Start date
L

Lynn Pennington

Hi.
I am working in a MDB file.
I can link MS-SQL tables but I only see table list.
Thanks,
Lynn.
 
Sure you can.
You just need permission on them in SQL Server before you try to link to
them.
Once you have permission you should see them in the table list too.
 
Under the database properties I look under
the "Permissions" tab. I have checked next to my
login...Create Table, Create View, Create SP, Create,
Default, Create Rule and Create Funtion.

Is there another place I should look. This does not
display the view list.

Thanks,
Lynn.
 
In the SQL Server database go to the specific User and check THOSE
permissions.
You need Select permission on the View itself.
 
Back
Top