Using a scheduled task to run an Access 2000 Macro

[paullem]

I'm trying to use a scheduled task on a Windows 2000 server to run an Access 2000 macro. The scehduled task runs a .bat file which contains an access command line. The task works fine if I set the task up on my PC and point it at the batch file on the server. But if I set the scheduled task up on the server it just sits there with a status of running. Can anyone help?

The command line is as follows:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "D:\Applications\StaffSafety\testschedule.mdb" /user Admin /X macro1

 

[smedvid]

I've done this before in the past couple of years and never used a BAT file. Can you simple open the file "D:\Applications\StaffSafety\testschedule.mdb", and make sure you have an Autoexecmacro that runs your code?

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[mp9]

Is Access installed on the server then?

At a PC level, a good solution to doing this kind of thing (and better than Task Scheduler, as it encrypts your db username and password, so it's more secure) is the Handy Access Launcher from

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