DCRAPACCESS
asked on
Access check if crashed
Hi Experts,
I have a Access database that should be running 24/7. But some times it crashes and i have to close it down and re-open it.
Can someone help m e with a solution that insures that access is still running and if not force close it and open it again?
Or something like that?
I have a Access database that should be running 24/7. But some times it crashes and i have to close it down and re-open it.
Can someone help m e with a solution that insures that access is still running and if not force close it and open it again?
Or something like that?
ASKER
Great idea, what if they run on the same computer?
And do you have some code I can re-use?
And do you have some code I can re-use?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
Each writes a file out to disk when it starts and when it finishes. Also at startup, you kill the last end file.
The other program then looks for these files and the timestamps of when they were created.
By looking at the end file, you can tell how long it's been since it's last run.
By looking at the end vs the start, you can tell how long it too to run.
By looking for a start with no end, you know if a program is still executing. By having a timeout value, you can tell if a program is hung.
By have the two programs run on two different machines, you can have a very sound check if it is executing properly or not.
This is of course with the programs being scheduled using Windows Task Scheduler and executing every xx minutes rather then running 24 x7, but you could use the same idea. Just have the app write out a status update to a file every xx minutes.
And BTW, I use files because it's easy to check from another machine, but any flag with a time stamp will do (ie. record in a table).
Jim.