Access automatically execute query at scheduled time? 1

[cs211024]

I know that using AutoExec macro can open a query at startup time.

Is there a way to execute query at scheduled time or automatically?

Any hint is greatlly appreciated.

Morgan

 

[mgolla]

Take a look at this application. I think you might like it.

http://www.geocities.com/waddly/accory.html

HTH
Mike

Dooobie...Doobie......Dooo

Beware the penguins

 

[Hillary]

FYI...There is a software out there called Automate that will run programs at scheduled times or when events happen. I think it's pretty inexpensive. We use it for running reports and utilities off our ERP system at night so the information is sitting on the printer in the morning.

Hillary

 

[cs211024]

thanks Hillary and Mike, I downloaded and installed the HAL, but it seems no working. Maybe some configuration is still needed. I am working on this way.

Morgan

 

[Wongy]

If you have the query you want to run as the autoexec macro you can schedule the job using MS Scheduler.

 

[mp9]

Better yet, the freeware Handy Access Launcher (HAL) -

http://www222.brinkser.com/accessory/resources/001.shtml