Unanswered: ODBC call failed - communication link failure
Any one have any suggestions??? I am trying to open linked tables in Access 2003 on Windows XP (Jet 4.0 Service Pack 8 is installed). The tables reside in a SQL 2000 DB. I can view the details of linked tables in design mode, but when I double click and try to open a table i get a Called failed message - Either Just "ODBC -- Call Failed" and the table opens with Name in all the cells, or
ODBC Call Failed
[Microsoft][ODBC SQL Server Driver] Communication link failure (#0)
then after closing that, a message pops up saying "Microsoft Office Access can't open the table in Datasheet view."
Linking to tables is not even consistent. Sometimes I can add a new link to a table and sometimes not. I tried deleting links then adding the same link again and even that is not consistent.