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

ARGroup wrote:
autoexec macro. That way you can use the Microsoft windows scheduler.
I recently used this approach for the first time and it works well.

"Bob Alston" <bobalston9 (AT) yahoo (DOT) com> wrote

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

On Jan 3, 11:22*am, ARGroup <heerab... (AT) gmail (DOT) com> wrote:
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.

"ARGroup" <heerabiji (AT) gmail (DOT) com> wrote

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
pleaseNOOSpamKallal (AT) msn (DOT) com