How to Link to SQL Views from MS Access ADP

  • Thread starter Thread starter Altemir
  • Start date Start date
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?
 
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.
 
Back
Top