Task Scheduler won't launch Access database

Question

Task Scheduler won't launch Access database

Darrell Burns 141

I've created a task in the Windows Task Scheduler that should launch an Access database (accdb) from a .bat file at 5:15AM every day. The Access database has an AutoExec that calls a Startup process that checks the command line to see if it's being called from the nightly schedule. If so, it then runs a bunch of queries that take approximately 75 minutes to complete.
When I launch the bat file directly, everything works fine. However, when launched from Task Scheduler it shows that the action was triggered and that the task is "running", but actually it isn't. The following screenshots show the setup and the launch. What am I not understanding?

Task_Scheduler_1

Task_Scheduler_2

Viorel 125.7K Reputation points

2023-03-10T15:15:23.48+00:00

According to https://support.microsoft.com/en-us/topic/considerations-for-server-side-automation-of-office-48bcfe93-8a89-47f1-0bce-017433ad79e2 “All current versions of Microsoft Office were designed, tested, and configured to run as end-user products on a client workstation”. However, your task is probably executed from a Windows Service (because you selected “Run whether user is logged on or not”), which is not supported.

Did you determine that only a part of your code is executed, and where does it stop?

1 answer

Your answer

Viorel 125.7K Reputation points

2023-03-10T15:15:23.48+00:00

According to https://support.microsoft.com/en-us/topic/considerations-for-server-side-automation-of-office-48bcfe93-8a89-47f1-0bce-017433ad79e2 “All current versions of Microsoft Office were designed, tested, and configured to run as end-user products on a client workstation”. However, your task is probably executed from a Windows Service (because you selected “Run whether user is logged on or not”), which is not supported.

Did you determine that only a part of your code is executed, and where does it stop?

Answer 1

Peter Doering 190 MVP

Viorel is correct with regard to scenario not being supported. However, technically it should still work. In your bat-file you have to provide the full path to Access and then path\file of your accdb.

Example:

"C:\Program Files (x86)\Microsoft Office\root\Office16\MSAccess.exe" "C:\Access\SCM_update.accdb" /cmd Nightly

(all in one line, separated by spaces)

Share via

Task Scheduler won't launch Access database

1 answer

Your answer