PDA

View Full Version : Ms access


jortega
Oct 26, 2006, 07:40 AM
Hi, How do I schedule a MS Access Query?

ScottGem
Oct 26, 2006, 07:49 AM
If you want leave the application open, then you can use the On Timer event to check the current time at a set interval. When the current time is later than the scheduled time you runt he query.

If you don't want to leave it open then you can use Windows Task Scheduler to open the app and run a macro then close the app.