Schedule Running a Macro

Hi Paul

Thank you for your question regarding scheduling.

Access does not include a method to automatically execute a procedure at a particular time unless the database was constantly open and a procedure constantly running to check the time. That causes issues with backups and is not a workable solution.

There are various products available that could open a file that executes code to manipulate your database, or your IT support team might already have a scheduling system that you could use.


Laura GB