run query every 24 hours

L

Lez

Hi Guys,

I am just wondering if it is possible to run a query ever 24 hours with no
user intervention?

I have some data that comes in at regular intervals and need to run my
update queries once the data has arrived.

Can anyone suggest a method please.

Thanks
 
N

NG

Hi,

you can design a seperate Access file, linked to your data file that runs
the update query on startup, and then closes automatically.

Then you can use the windows scheduler to start this access file every 24
hours.
 

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

format a time field in a query 2
Sum Hours over 24 hours in Access Report 0
Divide a a range of dates into intervals starting with the current date or the latest date in the ra 2
Create query to merge 2 tables? 2
Disapearing Query Results! 9
Field Created by Query won't be anything but "Binary" 2
Use query to copy data from previous row 2
Run query in another database 3

Top