Discussion Locked

Access Front End looses ODBC link when not active...

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access 2003 front end running on an MS SQL database linked via ODBC. Right now, it seems as though when the users go to lunch leaving the database open, the ODBC closes itself and the application in Access is not in use for a period of time, it acts as if the link goes to sleep. Is there a way to prevent this?

1 reply

by adam_wetch

The connection times out essentially.
Here is a possible resolution. Please let me know if this works, there may be other alternatives.
You can find a key in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC]

"ConnectionTimeout"=dword:00000258

Set that value to 0, and it should not continue to timeout.

This discussion is closed to new replies.