macro process running in task manager after the job is done

[Phillip]

I created a macro shortcut in access that is running a batch job. I used
windows scheduler to schedule that shortcut. It runs fine, but after the job
is done there is a process still running in the task manager. The next time,
when it runs the macro shortcut, it won't run it because there is the old
process hanging in the taks manager.
Does anyone know how to fix this problem?

Phillip

 

[Steve Schapel]

Phillip,

You might need to put a Quit action at the end of the macro, so it
closes Access after the other processing is done.

 

[Phillip]

I've done that. It closed out the ms access application, but the process is
still hanging with zero cpu utilization.
I found out that when you click the macro it works. It runs the macro. After
it finishes, ms access closes and there is no process in the task manager.

The problem occurs when you use the windows scheduler and try to schedule it.
The scheduler runs the macro to the end, but leaves the process in the task
manager even though the ms access application is closed.
How can I fix this problem in the windows scheduler?

 

[Steve Schapel]

Phillip,

I don't know what the problem is here.

Can you give the full details of the macro (all actions and relevant
arguments etc)... just in case it might give a clue to the problem.