I have a macro in Access that I need to run once each day. I created the macro, then created a scheduled task to execute the macro. When I right click and select "run" on the scheduled task it works perfectly.
However, once logged off and I let it run on its regular schedule it is not working. Access is indeed opening, but it is not running propely. It starts to run and opens Access, but it would appear the macro never runs and Access is remaining open, as if it is getting hung up. I have to go in some time later and kill the MSAccess process. However, if I am logged on I can watch the scheduled task execute and work properly.
I have checked permissions on all folders as well as the database that contains the macro and the adminstrator has full control. The scheduled task executes as the administrator as well.
Any advice would be appreciated!