I'm not sure whether this should go here or in the SQLServer area, but since we're using both, I'll post it here.
We're using Access 2003 to link to SQLServer 2000 tables via an ODBC connection.
When adding the connection, all tests complete successfully. We can then link in the tables correctly. I can open any one of the four tables in question and view all the data my little heart desires.
The trouble comes when we want to query the data in the SQLServer tables. If we run the query with no criteria, it shows the contents of the whole table just fine. If we set the criteria, then it produces an "ODBC call failed" error. This happens within about 5 seconds of executing the query, so I don't think it has to do with any timeout settings.
After the error occurs, no ODBC action of any sort can get through. It just reproduces the call failed error. The connection has to be deleted and set up again, or the tables have to be deleted and relinked.