ODBC Errors

  • Thread starter Thread starter Craigmeister
  • Start date Start date
C

Craigmeister

I have an Access 2003 mdb that is an FE to a SQL 2005 database. I began
getting ODBC errors and discovered I am unable to simply open linked tables.
The error is odd:

ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] Incorect syntax near 'Master
Not Codes'. (#102).

Clicking the Help button provides a reference to ODBC error 3146. This
happens on various linked tables and views that show as tables in Access.

Other folks are not getting the same errors, which leads me to believe it is
a problem on my PC, which is Windows XP SP2. So far, I have removed and
re-installed SQL Native Client, SP2 for Windows XP and IE 7 and repaired
Office from Control Panel...Add/Remove Programs.

Can anyone tell me if I am heading in the right direction or what should be
my next thing to try?

Thanks.
 
Try refreshing the links. If the table definitions change, Access doesn't
pick up the changes automatically as it does for Jet tables.
 
Refreshing the links worked for some tables, but not others. The tables
themselves have not changed and the other users are not having the same
errors in the Access MDB as I am. Any ideas for repairing ODBC on my PC?

Pat Hartman said:
Try refreshing the links. If the table definitions change, Access doesn't
pick up the changes automatically as it does for Jet tables.

Craigmeister said:
I have an Access 2003 mdb that is an FE to a SQL 2005 database. I began
getting ODBC errors and discovered I am unable to simply open linked
tables.
The error is odd:

ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] Incorect syntax near
'Master
Not Codes'. (#102).

Clicking the Help button provides a reference to ODBC error 3146. This
happens on various linked tables and views that show as tables in Access.

Other folks are not getting the same errors, which leads me to believe it
is
a problem on my PC, which is Windows XP SP2. So far, I have removed and
re-installed SQL Native Client, SP2 for Windows XP and IE 7 and repaired
Office from Control Panel...Add/Remove Programs.

Can anyone tell me if I am heading in the right direction or what should
be
my next thing to try?

Thanks.
Click to expand...
Click to expand...
 
Back
Top