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 ?

Signature
Allen Phailat Wongakanit
pmacdiddie@gmail.com - 15 Jan 2008 02:56 GMT
> Dear experts,
>
[quoted text clipped - 5 lines]
> --
> Allen Phailat Wongakanit
You can put an access database in your windows task scheduler with an
autoexec macro to start whatever code you need.
I
Tom van Stiphout - 15 Jan 2008 02:56 GMT
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.
>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 ?