create schedual for uptodate append query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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

Query help! 6
Access 2010 append query to SQL is very slow 0
Schedule Auto run Query on append table 0
Append Query Issue 0
Access 2007 - append query only appending 0 rows??? 0
Append query in Access to SQL Server 2
Help with Append Query 1
Pull a field from a form to be the criteria of an append query 0

Back
Top