Access ODBC to SQL Serever Views and Tables

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
 
V

Van T. Dinh

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL syntax for Access Pass Through queries (ODBC) 4
Linking to ODBC Linked Tables 2
Link tables ODBC 1
Linking ODBC Tables for Multiple Users 7
Link SQL 2005 tables with MS Access ODBC 3
way to not show tables only Views in ODBC connection 2
Manage ODBC 2
ODBC Linked tables keep on getting error 3151 5

Top