scheduling

J

jer

Is it possible to schedule an update query. I have inherited a database with
payment due dates and the payments are quarterly. Is it possible to schdule
an update query to to update the records to show the next due date once the
current date has passed.
 
M

Michel Walsh

You can schedule a task to run from Windows (XP, or Vista, and even in some
previous versions too). See the Task Scheduler, or something similar, in
your operating system.


The task you will launch is


MSACCESS.exe YourFullPathDatabaseName.mdb /X=macroName



where macroName is the name of a macro, in the database, to be executed. You
have to write that macro which will run the action query, and then close
Access.



Vanderghast, Access MVP
 
Top