General discussion

Locked

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

By gwIT ·
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?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Timeout.

by adam_wetch In reply to Access Front End looses O ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Forums