Scheduler

[Smudger Smith]

About 2 years agao I created a FABTASTIC database in Access that was scheduled to run each day. Since then I have move companies and now can't remember for the life of me how to create this in Microsoft Scheduler. I can get it to open Access, but not a specific .mdb and not a specific Macro

Please Help

Thanks

 

[allan57]

In the run parameter enter the database details to run:

"C:\Program Files\Microsoft Office97\Office\MSACCESS.EXE" "N:\Access_MDE_Runtime\AUDIT_PC_and_Network\AUDIT_PC_and_Network.mde" /x Audit_Import_Schedule

path to access
path to your database
macro to execute on startup

 

[Smudger Smith]

You are a gentleman and a scholar. Thanks for your help!