run query every 24 hours

  • Thread starter Thread starter Lez
  • Start date Start date
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
 
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.
 
Back
Top