Re: Run Query from Windows Task Scheduler
From: Frank Brown (FrankBrown_at_discussions.microsoft.com)
Date: Mon, 20 Sep 2004 09:23:02 -0700
Thanks for the response...
Actually, as I said in the original post, Windows has no problems executing
the Query. I double click it, and Access opens and runs the query. The
form idea would work, but as I said , I already can accomplish this with a
macro. I guess what I really want to know is why the task scheduler does
not work properly.
"Tom Ellison" wrote:
> Dear Frank:
> Not only the scheduler, but probably your system doesn't "know how to
> handle MAQ files."
> You can create a separate Access application to do this. That can
> then be scheduled. Use the Display Form/Page property you'll find in
> the Tools/Startup to cause this application to open a form when it
> runs. Use events of that form to run your query and close Access when
> it's done.
> Tom Ellison
> Microsoft Access MVP
> Ellison Enterprises - Your One Stop IT Experts
> On Mon, 20 Sep 2004 08:45:06 -0700, "Frank Brown"
> <FrankBrown@discussions.microsoft.com> wrote:
> >Using Office 2000 on windows 2000 sp 4, I created an append query in Access
> >to import data from a text file into an existing table. Query runs fine.
> > I created shortcut for the query, which also runs fine if double clicked.
> > If I schedule the query shortcut '.maq' file to be run by the windows task
> >scheduler, the task does not work. Scheduler reports "Status:could not
> >start". If I make a macro to run the query and then schedule the macro,
> >it runs fine. Seems that the task scheduler does not know how to handle
> >MAQ files. Is there something I am missing or perhaps an update that
> >would fix the scheduler?