Create .MDE file in scheduled task

[Guest]

We're having trouble creating an MDE file in a batch file called from a
scheduled task.

The following command file works when run by a logged in user, but in the
context of the task scheduler (Windows 2003 server) the MDE file never gets
created, and the task hangs.

net use P: \\s001\program
net use e: \\s006\intranet

"D:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"P:\Z_FXImport\CreateFXCO.mdb" /x "mcrRunCreateFXCO"

net use e: /del
net use p: /del

 

[Alex Dybenko]

Hi,
you have to check that task scheduler account has rights to all shares and
to run access and mdb. you can try with same account interactively and check
that everything works there

 

[Guest]

if by "task scheduler account" you mean the acount I specify in the task
schedule setup, then yes I have checked everything. It is an admin account
and the batch works perfectly if I run the task while logged in.
It does not make the mde file when the scheduled task is running in
background.

 

[Alex Dybenko]

Well, then you try to ask in windowsXP group, perhaps there is some trick.
Only thing i know that task scheduler account should have option "interact
with desktop", this you can set in service properties