Access lose connection to SQL Server when network down
-
Hi
We're running an Access application that connects to a SQL database on mixed mode via ODBC.
When the application is open, and doing nothing, and the nework cable is pulled out and restored for a short period (10-20 seconds), the application sometimes cannot recover and find the databae again. It needs to be restarted.
Is there a timeout setting where Access won't poll the database for x seconds, causing the application not to go down if it loses the connection for a short time?
(The ConnectionTimeout registry setting is set to 600 seconds, but it timeouts after 10 or 20).
-
If you are running the Access database from a server then this will happen if the database is self contained and not accessing external databases.
-
But shouldn't the connection to a SQL database be considered as accessing external databases?
-
Yes, the connection is to SQL Server which is an external connection.
The application gets installed on each client PC, but the tables in the application then gets connected to a central SQL Server machine.
-
But Sandy said what you described happens if the database is self contained and not accessing external databases.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply