Auto execute my qurey every morning 8:00 am, possible?

  • Thread starter Thread starter ali
  • Start date Start date
A

ali

Dear experts,

I have to run my MS Access query every morning at 8:00 am for other
departments, but i'd like to come to my office after 8:30.

Is there anyway to schedule a query to run ? if so , how ?
 
Dear experts,

I have to run my MS Access query every morning at 8:00 am for other
departments,  but i'd like to come to my office after 8:30.

Is there anyway to schedule a query to run ? if so , how ?
Click to expand...

You can put an access database in your windows task scheduler with an
autoexec macro to start whatever code you need.

I
 
On Mon, 14 Jan 2008 18:28:01 -0800, ali

Several options, including:
* Schedule a task to run on a machine that's always on and logged in.
This task would run your app with a special command line to instruct
it to run the query.
* Run the task at startup time of the application, but only once per
day. So the first user in the day will get a delay while this query is
running. At the end of running the query it will update a table to
indicate today's query has been run.

-Tom.
 
Back
Top