How to Link to SQL Views from MS Access ADP

A

Altemir

I am able to link to external data residing in SQL Server tables, but I
can't seem to do the same with SQL server views. When I go to "Get
External Data ..." in MS Access and select "Link Tables ...", I only
see tables. Is there a way to link to SQL views?
 
S

Sylvain Lafontaine

Not sure to understand the question here but if I'm correct, you will have
to set a linked server and access your external views from there.
 
Top