I have a front end database that links to a back end on a server. The server is switched off over the weekend and as such if the fornt end is opened prior to the manual switch on of the server (Windows Home Server) then there is an error 3024 "Could not find the file 'H:\xxxx.mdb'". I have tried to capture using AutoExec but the error fires before that point.
Is there anyway to capture the error and run code to advise need to turn on server and exit gracefully? I have to go this way as there are no options towake the server.
MS Access 2007
Client Windows XP
Server MS Windows Home Server
Any help appreciated.
Damon