Access ODBC to SQL Serever Views and Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

lI have created my ODBC connection. I can Link Tables in just fine, but I
also need to
link in Views and that are not appearing within my Link drag-down list.

Is my ODBC defined wrong in that I can link tables but not views???

Any help would be GREATLY appreciated!

Thanks.

wnfisba
 
SQL Views can be linked to an Access database and they appear as Linked
Tables in Access.

When I use File / Get External Data ... the SQL Server Views appear after
the SQL Server Tables

Do you have permissions to the Views on the SQL Server?
 
Back
Top