I have an ACCESS macro setup that runs inside its ACCESS database. I want to run it on schedule using task scheduler. I'm using MS ACCESS 2010 and Windows 7.
Here's my .bat file entry:
"C:\Program Files (x86)\Microsoft Office\Office14\msaccess.exe" "C:\ForAmy_NewProjectCoding - allprojectsB.mdb" /x APEXSummary
The .bat file runs successfully when double clicked from the c drive.
The ACCESS database never opens, hence the macro never runs, but the status on task scheduler states "Running". I end up just ending the task from task scheduler because it's not even running the macro.
I'm baffled by this because I do not see any error at all. It just does not launch ACCESS db.
Please help. Thank you.
Here's my .bat file entry:
"C:\Program Files (x86)\Microsoft Office\Office14\msaccess.exe" "C:\ForAmy_NewProjectCoding - allprojectsB.mdb" /x APEXSummary
The .bat file runs successfully when double clicked from the c drive.
The ACCESS database never opens, hence the macro never runs, but the status on task scheduler states "Running". I end up just ending the task from task scheduler because it's not even running the macro.
I'm baffled by this because I do not see any error at all. It just does not launch ACCESS db.
Please help. Thank you.