I set up a Scheduled Task on a Windows 7 desktop that opened Microsoft Access, then opened an Access database which had an AUTOEXEC to immediately run a report, save it as a .pdf, and then e-mailed this report to various people. The task was set to then close the database and the e-mail program. This was not ideal because the tasks were set to run on a computer in use and the environment had to be exactly right for the tasks to run (e-mail, Access closed, etc.). It ran fine if everything was "perfect" but failed if it was not, so I decided to set the same task up on a server. Unfortunately, I will not run. It says it is running but nothing ever happens.
Start a program.
Program/script: "C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE"
Add Arguments: "F:\Public\- ACCESS Databases\E-Mail\Weekly E-Mail.accdb"
Can anyone shed some light on this? I have tried a UNC path, changed the various options several times... it just does nothing.
The last time I ran it (tried to run it), I had to end it and it failed with an (Ox7D4) error.
I am the IT Manager and have full administrative rights.
Thanks in advance!