Autoexec macro is faulty

[ashley0578]

I have a db I set up to autoexec every time it opens. I have set my windows 2000 server scheduler to run the db at 5am, 11 am, 5 pm and 11 pm. Part of the macro is to update a table so I can keep track of what was outputted at that time into the excel files. My problem is that at the 5 am run, the table is not updating, although everything else is running perfectly. It updates perfectly at the other times. How can I fix this?

 

[FoFa]

Check your scheduled command to verify it is setup the same as the others.
I highly doubt it is access, it won't know 5Am from 7PM.
Something else is causing your issue.
Why do you say it is not updating?

 

[ashley0578]

Here is what happens:

I have my Window's 2000 Server Scheduled Tasks opening the db at those times. (I receive an email that the scheduled task occured plus the reports the macro outputs are updated so I know it's actually updating.)

The autoexec macro:
TransferDatabase - Transfer TRDATA
TransferDatabase - Transfer TRHIST

OpenQuery - Run Daily Query to update table
Close - Close Daily Query

OutputTo - RTF
TransferSpreadsheet - Excel
(Many spreadsheet transfers)

DeleteObject - Delete TRDATA
DeleteObject - Delete TRHIST
Quit - Close MSACCESS

My problem is when it runs at 5 am, it is doing everything BUT updating my table. It's outputting and transferring fine. At all the other times, it is running correctly and updating the table too.

I don't have anything else happening on my server at that time so I don't think that's the issue. Any help would be greatly appreciated!

 

[FoFa]

I would remove those delete objects, and after the next 5AM run, see what is in those tables, as a starting point.