Auto-run Queries

[bankonit9]

I would like to have a query run automatically each morning and export
onto my office share drive. I cant figure out how to set a timer of
some sort to schedule the daily run.

Is this something that can be done easily with a Macro or in some
other way in Access?

 

[John W. Vinson]

I would like to have a query run automatically each morning and export
onto my office share drive. I cant figure out how to set a timer of
some sort to schedule the daily run.

Is this something that can be done easily with a Macro or in some
other way in Access?

It's really easier to use Windows Scheduler to launch Access to run it. You
can have a Macro (one of the few cases I use macros) that launches the query
or code and then exits, and use the /x macroname command line switch to run
the query in the Scheduler command line. It would be something like

"%programfiles%\Microsoft Office\Office11\msaccess.exe"
"K:\somepath\yourdata.mdb" /excl /x macroname


John W. Vinson [MVP]

 

[ali]

hi John,

I understand your idea, and it sounds great. I only know how to launch a
file by using Windows Scheduler.

but i have no idea how to let it run a Macro.


and i do not understand the command line code that you have written. Will
you kindly explain it.

thanks a lot john !