Linked Table and S1T00 timeout error

[Jack A]

I have a client with an Access 2002 front end and a Sql Server 2000 database running on a Windows 2003 server. There is a linked table to the Sql Server db using the ODBC; type connection. After an update to the Server the connection times out with an error:



Conneciton fialed:
SQLState: 'S1T00'
Sql Server Error: 0
[Microsoft][ODBC SQL Server Driver]Login timeout expired

This occurs when the linked table is updated (well, when RefreshLink is executed).

I've tried recreating the linked table, but as long as this connection string is used it errors:

ODBC;Description=C3 SQL Server;DRIVER={SQL Server};SERVER=SQLSERV;UID=XXX;PWD=XXX;APP=Microso ft Data Access Components;

Anyone with any ideas?
Thanks, Jack

[llkhoutx]

Did you create a DSN for your SQL Server database. If so, I'd manually connect to the SQL Srerver tables and link those that are required. Then check the connection string in the "Connection" column of (hidden) table MSysObjects.