Scheduling a query to run

[TotallyConfused]

Can you schedule a query to run in Access automatically? If so can someone
please tell how to go about it or where I can find info how to incorporate
this into a database. Thank you in advance for any help you can provide.
Thank you.

 

[June7 via AccessMonster.com]

Do you want to run even when the project is not open? I have read some about
using Windows Task Scheduler to do this. Either through a .bat or .vbs file
or directly to Access. I tried opening Access through VBScript but not having
much luck. Here is the sample code I found:
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\filepath\mydatabase.mdb"

Also code for .bat file (again, I can't make work):
C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\myDB.mdb"
/macroname

If you only want to do it when project is open, what would be the condition
for initiating the action - when project opened, following data entry, time
of day? Here is one thread to check out:
http://www.tech-archive.net/Archive/Access/microsoft.public.access.queries/2005-06/msg01204.html

 

[Mark Andrews]

How about just make a macro that starts the process of running the query and
then checkout this article for
details on how to run access with command line arguments to start the macro
(from windows task scheduler):
http://bytes.com/topic/access/answers/197914-running-macro-scheduled-task

HTH,
Mark
RPT Software
http://www.rptsoftware.com