Detecting a Program Crash

Hi All

I have an Access 2007 database that runs constantly, the form on the database basically runs a timer every 10 seconds and runs a Macro. The problem I have is that when the backups run at night the network connection the database is on disconnects for the backup, so the database crashes with the error.

"Your Network Access was interrupted. To continue, close this database, and then open it again."

What I would like to do is create a small VB Application that runs on the machine that the database runs on, detects when the database has a problem, closes down the database process then restarts the database.

Is this possible? If so any help would be appreciated.

Regards

Douglas Bell

I would suggest another method. Since you are running a timer, get the time and shutdown the DB before backup starts. Then use the windows scheduler to start the DB up again at a specified time after the backup has run.

Use TASK SCHEDULER to start/stop your app. It can be automated.