I am trying to execute an Access front end from a scheduled task when the computer is signed out
The scheduled task invokes a batch file that in turn executes the Access database
This process worked for a long time but then stopped working
Windows 10 20H2 computers on Windows 2012R2 network
Batch file first saves a directory listing as a text file - to document that the batch file started
then executes the Access database
This works fine when I double click the batch file but Access opens then stops when the batch file is called by a scheduled task
I do not see any error events at the time the scheduled task executes
When I look at the scheduled task later it is still running
I scaled back the Access database to a AutoExec Macro that calls a Function and the Function consists on 1 command DoCmd.Quit
I also tried executing an Excel spreadsheet with a macro that quits and it also stops after being opened so the problem is not with Access