Scheduled Task Does Not Run when compueter is locked

[nishi1982]

Hi All,
I have written a batch file to run a macro in MS Access.
I have scheduled the batch file to run at a particular time of the day. The Task Scheduler and the batch file works fine until I lock the computer.
If the computer is locked, the scheduled task starts that brings up the access and when tries to execute the macro, halfway through the execution the Macro crashes for some unknown reason.

Does anybody had this problem before? or if somebody knows how to fix it then please let me know.

Thanks.

 

[Burglar]

I have had that happen but only after I change my domain password without changing it in the scheduled task.

 

[mp9]

Do away with batch files and Windows Task Scheduler by using the Handy Access Launcher, HAL (freeware from

http://www22.brinkster.com/accessory/resources/001.shtml)

to automate your macro runs... plus compacts and repairs too.

Runs fine when the computer is locked too...

 

[nishi1982]

Thank You for your sugesstions...