Scheduling Access Jobs

I used MS scheduler before I found this product from Spliterware ( they say – ‘System Scheduler is an excellent tool to schedule unattended running of applications, batch files, scripts and much more.’)

The sample screen below shows the setting I use with Access 2003

When used with Access I have a form called frmAutoLoad , when the form is loaded I have an on load event which checks the current time. If the time is not between 10pm and 6am I close the form and open the normal menu. I also add a time event which executes after 25 seconds, this lets the user stop the auto update process if used out of hours.

Once you have configured the event you can then schedule the occurances.