Can you link MS-SQL views??

[Lynn Pennington]

Hi.
I am working in a MDB file.
I can link MS-SQL tables but I only see table list.
Thanks,
Lynn.

 

[Joe Fallon]

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.

 

[Guest]

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.

 

[Joe Fallon]

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