title: MS Access dropping connection to ODBC tables after long period of inactivity
body: <p>I have an Access 2010 front end which has multiple linked tables on a local MySQL server (Windows) connected via ODBC. Most of the time it works just fine however Access drops the connection if left for several hours with Access open but not being used. When a form is opened again I get an ODBC error.</p>
  
  <p>The problem is fixed by closing Access and opening it again.</p>
  
  <p>I'm guessing that it's a timeout issue but I'm not an Access expert. It seems that I need a way of checking for a valid ODBC connection and if necessary, re-connecting?</p>
  
  <p>Any ideas?</p>