I'm using Windows Server 8 and I'm having a real problem launching my Access 2010 database from Task Scheduler. As I can see the problem is not new, but I hope, if somebody found a solution, maybe they'd share it with me. This is what I've tried:
- Running with highest privileges,
- List item
- Run when I'm logged on or not,
- I have a Domain Admin permissions,
- The batch file, all folders, sub folders and the database have FULL permissions to my security level;
The task launches a batch file, which is supposed to run the whole thing, and it does if I run it manually. So there is no problem with the code or the script.
What I can see is that the Access file is being created, assuming that the bat file actually launched at least Access object, but id doesn't go any further.
I've also tried the VBScript:
dim accessApp set accessApp = CreateObject("Access.Application") ' accessApp.visible = True accessApp.OpenCurrentDataBase("\\...Path to my DB.accdb") accessApp.Run "NameOfMyFunction" accessApp.Quit set accessApp = nothing
No success either! Windows Server 2008 R2 Standard, SP1, 64-bit.
Here is the script from the batch file: echo PROCESS STARTED %date% %time% >>\servername\FolderName\JobLog.txt "C:\Program Files (x86)\Microsoft Office\OFFICE14\msaccess.exe" "\servername\FolderName\DbName.accdb" /x mMacroName
Task Scheduler acts like there is nothing wrong, No error messages, the history shows all steps until "Created Task Process" and doesn't go any further. I see that my database creates a lock file, but the script within the database that writes into the log file doesn't run. The goal here is to activate macro, which runs action queries (DELETE, APPEND ... all that jazz.) and at the end closes the database. As you could see I've added a line in the batch file to write into the log file before launching the database. Not doing it.
Thank you in advance for the time you spend reading this