create schedual for uptodate append query

[Guest]

I have several access Append Querry that uptodate daily data from one table
to another table, I want to schedual these queries run everyday at
12:00:00AM, I like to know is there any commend in Access like SQL Server
that I can Schedual my job (Running Append Querry, or any queries in a
specific time in a day)
Thank you
Sima

 

[Dale Fye]

No,

But if you don't mind leaving your Access application open 24/7, you could
put some code in a timer event of a form and test for the time every minute
and when it reaches 12:00:00 AM, run the append query.

Another way would be to use the Windows Scheduler to kick off an Access
application that has an autoexec macro which runs the append query(s) and
then quits.

HTH
Dale