Can query be set to run at say 4:00 am?

[Dan01]

Hi, does anyone know if one can schedule, within Access, the time in which a query runs? Thanks, Dan.

 

[JeanineScott]

The way I have handled this is to set up Norton or Windows scheduler to open your application at a specific time, then on open of the application write some code to check for the time. If the time is beteen 3:55 and 4:05 AM then execute your process.

Hope that helps!

 

[Dan01]

OK, Thanks!!! Dan.

 

[Junior1544]

well, they way i would do it... (not saying JeanineScott isn't doing it a good way...) is to have windows scheduler (or any program scheduling app) run the database with a command line switch... because that way it will exit back out when it's done... this way you can also put in a username and password if it's a secure database... that, and i'm not good at programming good luck...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[Dan01]

Thank you Junior. Your quotation reminds me of George Harrison, "All things must pass".

 

[Junior1544]

thanks... i have heard it once or twice befor... but it just came to mind as i was making my signiture

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[JeanineScott]

Are you saying that scheduler can automatically close your application for you too? How does it know when your process is finished? I have it open the app (via the command line) and then when my process is done I exit the app via code. (docmd.quit) Is there another way to do it? New options are always fun to try!