run scheduled MS Access batch job

[kjcook]

I am running Microsoft Windows Server 2003 R2 with MS Access 2007. I have written a batch job that opens up MS Access and runs the macro then closes. I have the batch job set to run every monring. The batch job is set to run as the user "ABC". The batch job seems to hang every time it runs. However, if I login to the windows box as "ABC", goto the Windows scheduled and right click on the job and run it. The job runs to completion as I want it to. Why will the job not run as scheduled?

Here is the batch job:
c:
cd "\Program Files\Microsoft Office\Office12 "
Msaccess.exe e:\tanks\rgrtrc k97.mdb /x Export_FedReg /ro /nostartup
Msaccess.exe e:\tanks\rgrtrc k97.mdb /x Export_RgTrck /ro /nostartup
exit

[zmbd]

You need to check the local machine policies and make sure that your script can actually run without having an interactive login started. Most of the time this is disabled by the Admin as there is a security risk.

Also, you need to use the [code][/code] tags around your code.

-z