Query to run automatically at midnight

[Jacobingram]

I wish to have one of my make-table queries run automatically at midnight every day. The access database will be running on the server at this time.

I have searched for a solution but found them quite hard to understand.

Thanks in advance for your help

 

[namliam]

You could create a form which has a Timerinterval set to 60000 (60 seconds)

Then in the "On Timer" event

If Format(now(),"hhnn") = "0000" then
currentdb.execute "YourQuery"
endif

But that would mean running the database. If you have rights on the server you could use something like at or some other schedular to run the database at midnight

Regards

 

[Jacobingram]

Thanks very much - Exactly what I needed!!