Scheduling Access query

[ARGroup]

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

[Bob Alston]

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.

[Fred Zuckerman]

"Bob Alston" <bo********@yahoo.comwrote in message
news:m2*************@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

[ManningFan]

On Jan 3, 11:22*am, ARGroup <[e-mail]:

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.

[Albert D. Kallal]

"ARGroup" <he*******@gmail.comwrote in message
news:b5**********************************@d21g2000 prf.googlegroups.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/AlbertKal...obs/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
pl*****************@msn.com