Run Access Queries at a specified time each week systematically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that takes a long time to run, and I want to know if anyone has a way to run the query at a specified time each week systematically. Basically, I want to schedule my query to run each monday morning around 6:30 so that it is done when I come in at 7:30

Any thoughts?
 
Dear Andy:

Create a separate database that runs this query when it opens, then
exits.

You can then schedule Access to run this database with the scheduler.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top