Re: Scheduled Task Hanging

"Kayda" <blairjee@xxxxxxxxx> wrote in message

I have also posted this question in microsoft.public.access but
thought after the fact that I should post here as well.

I have an Access macro that I schedule using the Task Scheduler in
WIndows 2003 to run once per day. When the time comes, Access opens on
the desktop, queries are run, the Access window closes. However, in
the Task Scheduler it still says "running" and in Task Manager it
still has MSACCESS.EXE. The code itself is simple, I just issue a
"Quit" in Access, which works in a sense because it shuts the window.

So from a windows newsgroup/task scheduler perspective, is there
anything I can do to ensure the msaccess.exe process is killed after
it is finished?


No, there isn't, because the task hangs under Access, not under
Windows. Log on to the machine under the same account as the
one used for the scheduled task, then watch when the task runs
so that you can see why exactly it hangs. You will then know
what to do to let it finish its job. I strongly suspect that you have
a permissions issue or that you are relying on mapped drives
that do not exist.


Relevant Pages

  • Re: computer freezing
    ... Applications in Task Manager just showed Windows ... XP Newsgroups (Is this Task Scheduler or must I look elsewhere?) I ... We have Kaspersky Internet Security. ...
  • Re: Kamaelia 0.4.0 RELEASED - Faster! More Tools! More Examples! More Docs! ;-)
    ... Windows users might see problems with the attempt at importing ... I'm planning on an Axon 1.5.1 ... actually remove this code from the scheduler completely. ... simple physics model the visualiser uses not having sufficient ...
  • RE: server 2008 task scheduler problem
    ... perhaps I have solution for you - in Windows Vista it solved the problem ... ..NET Passports for network authentication" in Group Policy ... the task scheduler seem not running well in server 2008 ... Error message: the following error was reported: A specified logon session ...
  • Re: reason for AMDs Bulldozer fiasco?
    ... the Microsoft scheduler will just as willingly ... inferior product, but it won't be quite as disappointing for Windows, ... There was no real reason ever given at the time, and that was a period of time when it looked like AMD was doing really well too, but we can now guess in hindsight. ... They are talking about bringing out a new stepping that won't result in better single-threaded performance, but in better power management. ...
  • Macro Scheduler version 9.0.053
    ... software to automate any Windows task; ... Macro Scheduler lets you create macros to control your Windows applications, ...