Frequency formulation of bat execute access query

Asked By ave broers 70 points N/A Posted on - 11/22/2012

I am aware that a make-table query can run and save from a pass-through query to a new table. 

I have a dilemma though because I do not know how to schedule it to run on a certain frequency.

How can I make bat execute access query to run every other day?

• Status: Open
• Question Views: 789
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By May Jratr 0 points N/A #151640

Frequency formulation of bat execute access query

Hi Ave Broers, 

Hope that my message finds you well, 

 

I think that you can use (windows schedule) to schedule the query to run everyday. 

 

You can use a macro to call the needed query after that you can call the macro with the scheduler. 

 

Please check the following URL (How to start access by using windows scheduler ) for more info. : 

https://support.microsoft.com/en-us/help/230575/acc2000-how-to-start-access-by-using-the-windows-nt-schedule-service

 

Hope that this will help you. 

 

Thanks,

About May Jratr

Questions
2

Answers
100

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: MS Access