By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,056 Members | 1,320 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,056 IT Pros & Developers. It's quick & easy.

Scheduling Access query

P: n/a
Hi all
Is there any method to schedule Access queries to run regularly?If yes
pls mention how it is being done?
Jan 3 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
Jan 3 '08 #2

P: n/a
"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
Jan 3 '08 #3

P: n/a
On Jan 3, 11:22*am, ARGroup <heerab...@gmail.comwrote:
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.
Jan 3 '08 #4

P: n/a
"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
Jan 4 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.