Access link with MS SQL Server

  • Thread starter Thread starter Kmon
  • Start date Start date
K

Kmon

I am using an ODBC link to a SQL Server database for about
5 tables. All 5 seems fine until I go to queries and try
to create a query. On just ne of the tables I get a
message 'Invalidobj.name'table_name'(#208). Why is
working for the rest, but not this one table?
 
You would be better off using the native SQL Server driver than using the
ODBC driver. ODBC drivers would be used for those databases that do not have
a native driver for Access.
 
You must log in or register to reply here.

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

Connecting to MS SQL Server 1
TransferSpreadsheet method question 2
SQL Connection Error with MS Access 7
Can't link to MS SQL Svr 2005 table (#deleted) 8
Linked SQL Server tables in Access 4
Sql Server linked table and NULL bit fields 2
Problem with ODBC linked tables in Access 2003 0
Access 2007 on Vista and Linked Tables 2

Back
Top