Thread: Scheduling a query to run

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/.../msg01204.html