Hi
I am trying to run a macro via windows scheduled task within MS Access 2010. It works when the task is set to run only when logged in but not when using the option 'run whether user is logged in or not'.
Program/script: "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"
Arguments: "E:\access\access.mdb" /X AutoRun /excl
The database extracts data into various text files and places them on the drive.
When it does work as mentioned above, the msaccess.exe windows process runs for about 10 minutes and then the process terminates on completion. The text(s) file modified date changes and this proves the files have been updated.
However when I am trying to do it as mentioned above, the MS Access process remains after 10 minutes and doesn't produce new data within the text files.
I have confirmed that the task is running, but never ends. I have waited for 30 minutes.
Any advice would be much appreciate
Thanks
Matthew