Question
May 31, 2007 at 06:36 AM
scarlet christiaans

Restart Access using VBA

by scarlet christiaans . Updated 19 years, 4 months ago

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?

This discussion is locked

All Comments