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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show the most recent payment 5
The query cannot be completed. 1
Creating an update query that uses multiple parameters 2
Can't solve this query problem. 3
Table/query layout trouble 2
How do I find the last record ? 5
Current payment due 1
Another most-recent date query 0

Top