Access hangs Windows Scheduled Task unless logged on on Windows Server
Posted on 2009-12-20
Trying to run batch file which opens Access database and runs a macro.
Scheduled as Windows Scheduled task.
Batch file will run if logged on.
When set to run for when not logged on (by providing username and password) the job will run but hangs. The task shows as running and in the task manager can see that Access is running.
However, the job does not do anything.
I have researched this quite a bit on EE and have ensured:
1. The macro quits Access when completed.
2. I have put the batch file and the Access database in the MyDocuments folder for the user.