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.
 
Back
Top