General discussion

  • Creator
    Topic
  • #2276312

    Access Front End looses ODBC link when not active…

    Locked

    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?

All Comments

  • Author
    Replies
    • #3291143

      Timeout.

      by adam_wetch ·

      In reply to Access Front End looses ODBC link when not active…

      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.

Viewing 0 reply threads