I am trying to use Vista's Task Scheduler to open an Access 2007 (.accdb) database on a daily schedule. Once open, the database has an AutoExec macro that will launch...run some code...then the last action in the macro is "Quit" to close Access.
This is the first time I have ever used Task Scheduler (on any version of Windows).
Everything works perfectly when I manually open the file.
Task Scheduler does attempt to perform the action, but fails.
Error Message is:
Task Scheduler failed to start instance "{17d769db-fd7c-41dd-9e6e-b45cea05c48e}" of "\mytestautomailer" task for user "JPS_PC\JPS-Admin" . Additional Data: Error Value: 2147942593.
I tried searching this site and have not found this issue. I also searched the web and only found a couple forum posts...however they weren't in English...doh!
Here's what I am thinking...
Since my task scheduler seems to be working and the Access database seems to be working...then my issue is how these two are working together.
I have tried setting the task to "Run with the Highest Permissions" and that did not work...thinking maybe it was getting denied access.
There is the option to put command line arguments in there, but I haven't found any information regarding needing to add any nor any information as to what would need to be added.
Hmmm...as I am typing that last part I am starting to wonder if I need to use Task Scheduler to open Access and then a command line argument to open the database...hmmm...I will explore this idea and post back the results.
Thank you in advance for your time and assistance.
JPS
This is the first time I have ever used Task Scheduler (on any version of Windows).
Everything works perfectly when I manually open the file.
Task Scheduler does attempt to perform the action, but fails.
Error Message is:
Task Scheduler failed to start instance "{17d769db-fd7c-41dd-9e6e-b45cea05c48e}" of "\mytestautomailer" task for user "JPS_PC\JPS-Admin" . Additional Data: Error Value: 2147942593.
I tried searching this site and have not found this issue. I also searched the web and only found a couple forum posts...however they weren't in English...doh!
Here's what I am thinking...
Since my task scheduler seems to be working and the Access database seems to be working...then my issue is how these two are working together.
I have tried setting the task to "Run with the Highest Permissions" and that did not work...thinking maybe it was getting denied access.
There is the option to put command line arguments in there, but I haven't found any information regarding needing to add any nor any information as to what would need to be added.
Hmmm...as I am typing that last part I am starting to wonder if I need to use Task Scheduler to open Access and then a command line argument to open the database...hmmm...I will explore this idea and post back the results.
Thank you in advance for your time and assistance.
JPS