Using Task Scheduler to Run a Macros Gives An Error Message

[Guest]

Using Task Scheduler to Run a Macros Gives An Error Message When Closing.

I created a scheduled task that runs a macro. The task starts fine, Access
is opened, the macro does what its supposed to do, then ends. But instead of
closing after 1 minute as scheduled by the Task Scheduler, Access gives an
error message:

"Microsoft Access for Windows has encountered a problem and needs to close.
We are sorry for the inconvenience...Send Error Report, etc."

Access just hangs with this message box activated in the foreground.

note:
I noticed that when the task/macro is run, Access is not activated in the
foreground. If I click to activate Access in the foreground BEFORE the
scheduled task close time (1 minute after run) then it closes normally
without error.

Can anyone tell me how to avoid having to click in the Access window to get
it to close without error?

I'm using Windows XP SP-2

 

[Steve Schapel]

KJalon,

What are the actions in the macro? And what is the Command Line that
the Task Scheduler is trying to execute after 1 minute?

 

[Guest]

The problem is solved! I looked at my actions again and realized that I left
out the "Quit" action to close the program. I must have overlooked it when I
was creating my macro. This was my first time creating a macro so I guess it
was a beginner's mistake.

No need for any modification of the Task Sheduler.


Thanks for the simple question Steve!