Automatically running queries

C

chrisg29

Hi,

I have 2 make -table queries that I have to run evry day, is there a way
that I can make the 2 queries run by themselves at say 12 every night?

Thanks,
Chris
 
A

Andy Hull

Hi

Yes.

Create a macro with 3 actions
1: openquery first query
2: openquery second query
3: quit

Then, use the windows scheduler to open the database & run the macro
whenever you want...

Go into control panel
Choose "Scheduled Tasks"
Set up the task with a command line with the following structure...

Full Path and filename of Access executable
Full path and filename of access mdb
/x
Macro name

E.g.
"C:\program files\msoffice\msaccess.exe" "MyDBName.mdb" /x macMyMacroName

The /x tells access to run the specified macro

hth

Andy Hull
 
P

Pieter Wijnen

Or make a hidden Timer Form
Or Write a small vbs app to do it & use Windows schedule (my preferrred way
of doing it)

HTH

Pieter
 
Top