Monitor Access Program

[JesseH]

We have a critical program that executes continuously. We have a dedicated server that only has this database on it. The problem is that once in a while it hangs up and we do not know about it. This causes us problems. Is there anyway that I can monitor the program and find out when it fails (hangs up).

We are using a window 2003 server and Access 2003. The program is written in VBA.

Thanks in advance for your assistance.

 

[DJkarl]

As someone who is in a similar situation I can say I have not found a reliable way to do this. Adding extensive logging to the process then checking the log file/table is one way to go. There isn't a rock solid method, and Access is prone to random hangups, I had an Access application running daily for nearly 2 years without an issue, then one day bam! It didn't want to run until I recompiled the code, it could have been corruption or the result of a Windows Update, but there is no telling really.

 

[JesseH]

Thanks for trying. I did not think there was an easy way to do this, but I thought I would try.

Thanks again for trying.