Run Access Queries at a specified time each week systematically

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?
 
T

Tom Ellison

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
 

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

Schedule Auto run Query on append table 0
Query producing different results each time it is run 2
how do I query daily records by week? 1
Combine Duplicates in Query 0
Extract data from previous week, previous two weeks, etc. 2
Fixed Values in a Query 5
adding a column each time query is run... 1
SUM in a UNION query 2

Top