How can I set-up Access to run a query at a scheduled time?

[Guest]

I need a an Access database to run a query at 11pm every night when no one is
on our server. How do I schedule Access to do this so that I don't have to
be here at 11pm?

 

[Duane Hookom]

I would use the Scheduler
http://www.mvps.org/access/resources/downloads.htm#S or something similar to
start Access with a macro in the command line that would run the query.