Scheduling Access query

Hi all
Is there any method to schedule Access queries to run regularly?If yes
pls mention how it is being done?

Re: Scheduling Access query

ARGroup wrote:
> Hi all
> Is there any method to schedule Access queries to run regularly?If yes
> pls mention how it is being done?
YOu can set them up in a separate access database and run from an
autoexec macro. That way you can use the Microsoft windows scheduler.
I recently used this approach for the first time and it works well.

Re: Scheduling Access query

"Bob Alston" wrote in message
news:m28fj.46$dP7.36@newsfe07.lga...
> ARGroup wrote:
>> Hi all
>> Is there any method to schedule Access queries to run regularly?If yes
>> pls mention how it is being done?

> You can set them up in a separate access database and run from an autoexec
> macro. That way you can use the Microsoft windows scheduler. I recently
> used this approach for the first time and it works well.

Or you could use a form and the timer event.
Fred Zuckerman

Re: Scheduling Access query

On Jan 3, 11:22=A0am, ARGroup wrote:
> Hi all
> Is there any method to schedule Access queries to run regularly?If yes
> pls mention how it is being done?

Both methods mentioned work perfectly when set up properly. It
depends on what exactly you're trying to do.

Is this something that you plan to run over the course of the day?
Is this something that you plan to run only when the database is
open?
Is this something that you need run on a network, no matter what the
time of day?

Depending on the responses the most efficient way to do this can be
proposed.

Re: Scheduling Access query

"ARGroup" wrote in message
news:b5dfc9e3-cb5a-4267-9042-e33fc3a185d3@d21g2000prf.google groups.com...
> Hi all
> Is there any method to schedule Access queries to run regularly?If yes
> pls mention how it is being done?

I explain how to run ms-access code via a script which is happily run by the
windows scheduler...


http://www.members.shaw.ca/AlbertKallal/BatchJobs/Index.html


So, simply place some code in a standard module that runs the sql you want.

Public Sub MySqlToRun

currentdb.Execute "name of query"

end sub


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com