Schedule WIndows 7 Task to run Access 2010 Macro
Posted on 2012-03-26
I am trying to run an Access 2010 module as a daily Scheduled Task on a Windows 7 Professional operating system.
This will run at night when my computer is logged off.
I have the Action: Start a program
Program/script: "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE"
Add Arguments (optional): "C:\Scripts\DailyReports.accdb" /x mcrEmailPOlines
Start in (optional): blank
I have this set to run whether user is logged on or not and to run with the highest privilages.
It is configured for WIndows 7 and WIndows SErver 2008R2
It looks like the task kicks off, but the follow message shows for the Last Run Result
The task is currently running. (0x41301)
This status will not change. I eventually end the run.
After it tries to run, when I open Access, I get the message:
Access failed to start correctly last time. Starting Access in safe mode will help you correct or isolate a startup porblem in order to successfully start the program. SOme functionality may be disabled in this mode. Do you want to start Access in safe mode.
I even tried to run a batch file to kick off the macro from Task Scheduler with similar results. Double clicking the batch file works fine. I just hang in Task Scheduler.