By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

run scheduled MS Access batch job

P: 1
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\rgrtrck97.mdb /x Export_FedReg /ro /nostartup
Msaccess.exe e:\tanks\rgrtrck97.mdb /x Export_RgTrck /ro /nostartup
exit
Aug 7 '12 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,285
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
Aug 7 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.