Hi,
I have an access database that connects to remote mySQL tables through ODBC connections. This db has a form that tries to access these remote tables every 3 minutes, and runs 24/7. If the ODBC connection call fails (as it sometimes does), an error message pops up (ODBC–call failed), and I have to choose “end” or “debug” on the following popup, then close/re-open the database and all is well.
I’d rather catch the ODBC error and restart the database.
I’m wondering if there is a way to restart Microsoft Access using VBA?