I have MS Access 2003 application connected to SQL Server 2005 with linked tables. Starting from yesterday when I open a linked tabled and leave it open for a while (5~10 minutes) then the database gets disconnected showing following error message. What can be wrong?
INFO: I did not change any configuration for ODBC timeout and my Database admin says that he did not change anything on the server either.
What should I check?
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead(recv()). (#10054) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Genral network error. Check your network documentation. (#11)