I have an On Timer event on my main form set to run every day at 6:00 AM. It runs a macro that generates a report and saves it in PDF in a folder. It works most of the time but for some reason when the customer comes in at 7AM and checks the folder the report is missing. This fails to run maybe twice a week. The Access DB runs 24 /7 and is used on all shifts. I am wondering if the monitor is going into screen saver mode and causing issue. I have only been able to reproduce it on my PC once by leaving the DB running over night and then I checked it in the morning and it was missing. If I try to duplicate it by changing the time that it should run and then letting screen saver start, it will not fail.
Here is my code in the Form timer:
The time interval is set to 35000, so that it will catch the 6:00 AM. Could the last set of 00's be causing the issue? Could this be removed?
Is there a log that I can turn on that will show if it tried to run and why it failed?
I just read a thread that said Access was not designed to run 24/7 without being restarted. Is this true and could it be my problem?
Thanks for any ideas
Rick
Here is my code in the Form timer:
Code:
Private Sub Form_Timer()
If TimeValue(Now()) >= #6:00:00 AM# Then
Dim stDocName As String
stDocName = "DailyDownTimeChart"
DoCmd.RunMacro stDocName
Me.TimerInterval = 0
End If
End Sub
Is there a log that I can turn on that will show if it tried to run and why it failed?
I just read a thread that said Access was not designed to run 24/7 without being restarted. Is this true and could it be my problem?
Thanks for any ideas
Rick