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 ?



--
Allen Phailat Wongakanit

On Jan 14, 9:28*pm, ali <a...@discussions.microsoft.com> wrote:
> 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 ?
>
> --
> 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

On Mon, 14 Jan 2008 18:28:01 -0800, ali
<(E-Mail Removed)> wrote:

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 ?