Access database fails when using Task Schedular

[tcheck]

I have an Access database that sends an email to users when there is an exception in the query. It works fine when I run it from Windows 7, but when I use task schedular I get an error message;



runtime error 429 activex component can't create object

and the error stops a;

Set olapp = New Outlook.Application

It only happens when i run it from Task Schedular.

[June7]

How does Task Scheduler do this - it opens the Access db?

[tcheck]

Yes. The database opens and I have a form that runs On Load and the script in in there.

[June7]

Could you describe exactly how you set up the task to directly open the specific database?. It is something I tried to do a long time ago and abandoned. If I can replicate the scheduled task I can then test the email procedure.

What I have in place is Scheduled Task to run a VBScript that opens the database and code behind default form sends email. Works great.

[tcheck]

It runs a batch file to open that Access Database. Her is what is in the batch file;

"C:\Program Files (x86)\Microsoft Office\Office14\msaccess.exe" "J:\operations\FTP\AuditTrail\AuditTrailAlerts.acc db"

[June7]

Okay, then you are doing the same thing I am. No idea why it fails for you. Would have to test the db. Here is my VBScript code (Access 2007 under WindowsXP):

Dim objFSO, oShell
Set objFSO = CreateObject("Scripting.FileSystemObject")
'open the Access file
Set oShell = CreateObject("WScript.Shell")
oShell.Run """C:\Program Files\Microsoft Office\Office12\msaccess.exe"" ""\\dotatufs02\CRM\Lab\Database\Program\Editing\Ma terialsDatabase.accdb"""

[tcheck]

It's odd that it only happens when run from Task Manager.

[June7]

I can't replicate the issue. Mine works just fine.

[pbaldy]

Is the PC logged in when the code runs from Task Scheduler (TS)? I have automated email code run from TS and it works fine. Mine is logged in but locked at the time it runs.

I use late binding, but I can't imagine that would matter. I also run the db directly from TS without a batch file, but as I recall I had trouble with accdb format so made mine an mdb.

[June7]

Paul, what is the structure of the command strings in the Scheduler that work for you without script file? I have tried for both mdb and accdb. Nothing happens. The file doesn't open.

[pbaldy]

Is this what you're after (should have clarified my PC is Win 7 Pro 64 bit)?

[June7]

Looks like the Scheduled Task utility has changed significantly with Windows7 'cause not seeing that with WindowsXP. I will have to test with Windows7. Thank you, Paul.

[pbaldy]

No problem. I remember really wrestling with it and could not get an accdb to run, but had no problem with the mdb.

On a side note, I have a PC I remote to in Las Vegas that is Win XP Pro and I have several mdb's running directly from Scheduled Tasks there (numerous automated imports, but also an email sending app). Not sure why you had to use batch file to run, as the path in "Run" is similar.

[June7]

Finally figured it out. I needed some more quote marks. Doh! Only took 3 years. Works with the accdb. Now to go test Windows7.

[tcheck]

When I run the Access command directly from TS in W7 it states that it's running but nothing happens (Access does not open) that is why I had to create the batch file.

Is there a differnent command that I shoudl use instead of the Set olapp = New Outlook.Application where it hangs in the TS task?