By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Running append and update queries automatically on a weekly basis

P: 1
I have some append and update queries that I have put in a macro. Instead of AutoExec which runs when the database is opened, is there a way to have the macro run at a certain time? I am using Microsoft Access 2003.
Oct 29 '08 #1
Share this Question
Share on Google+
1 Reply


DonRayner
Expert 100+
P: 489
I have some append and update queries that I have put in a macro. Instead of AutoExec which runs when the database is opened, is there a way to have the macro run at a certain time? I am using Microsoft Access 2003.
Why not just make another table with 1 record that has the Date/Time that the macro was last run. Then on startup check that table against now() to see if the correct amount of time has elapsed since the last run. If it hasn't don't do anything but if it has run the macro. You can then change your macro to also update the run date in your table.

Don
Oct 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.