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