Q:

Run MS Access mdb with task scheduler

I want to simply open an MS Access MDB file with task scheduler, but it just says "running" and leaves MS Access open in the background which I can only see in the task manager.
I have an AutoExec macro that does it's thing and then closes itself. Works fine opening the program manually, doesn't do anything when opened from task scheduler (Including clicking run on the task myself).
I've seen many ask this online, but have found no solutions.
Here's what I have in the Task Scheduler:
Program/Script: "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"
Add arguments (optional): C:\[TheDirectory]\SCServerData.mdb
I have other Task Scheduled .bat files that run with no problem.

A:

Turns out it's quite simple actually. I just put the command in a batch file instead and run that with Task Scheduler. Seems to be working so far.

