Question How do I schedule MS Access tasks?

[apeters]

Hello, I'm fairly new to MS Access (2003) and I'd like to know how to execute Procedures/Macros automatically to a predefined schedule. Does anyone know of any good Tutorials or articles on this?

 

[pbaldy]

Two ways generally. One is to use the timer event of a form to fire off the procedure at the desired time. That obviously requires that the db be left running. I typically create an mdb that performs the desired task when it opens, then it closes itself. Then I run that mdb from Windows Scheduled Tasks.

 

[apeters]

Thank you

 

[pbaldy]

No problem; welcome to the site by the way.