Need to use scheduled task to run an access macro

[Michael57]

I would like to run access automatically at a few times during the day with this command:"C:\Program Files\Microsoft Office\Office\msaccess.exe" "L:\CNC Schedule\CNCSchedule.mdb" /X Send Cam Schedule To Web but I cannot get it to work in the task scheduler. Can anyone help me with the setup

 

[mp9]

Try the Handy Access Launcher, avaialbe from

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

- it is specifically designed to run Access macros at scheduled times, as well as doing scheduled compacts and repairs.

 

[XP2000]

I have been using MDBTask which is available from

http://www.pb-sys.com

in the retired products section.
It's free and works well for me.