I want to write a script or program to detect If the MS Access application running without errors. If there was an error I would like to know the error number. Is it possible? What is the best way? I would like to write VBScript and run it every 30 minutes. The Access Application that I have is on MS Access 2003.
+4
A:
I suggest you write out a log file from the access application. You can use an error trap and the error function to get details of any error that has occured. I do not see how you could do this from VBScript, other than to read such a log.
Remou
2009-09-28 08:21:42
tnx.This application is third party application. I can not change any codes. lately It started to have some errors. I have a timer to run this application and I just wondering if it was possible to check if this application has an runtime error from remote computer or from different program.
THEn
2009-09-28 16:02:27