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.
 
Top