We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Macro "running" in Task Scheduler

Microbomb
Microbomb asked
on
Medium Priority
923 Views
Last Modified: 2008-03-10
I have Windows Task Scheduler running a macro in Access that runs a couple querys and exports a csv file. It works perfect but the task scheduler says the task is still running and indeed Access stays open after the macro is done. How can I get it to close Access when the macro is done. I tried putting a close macro at the end of the macro but it doesnt work. Thanks.
Comment
Watch Question

Hey Microbomb,

Try putting the "Quit" action as the last action in the macro!

\|/ Jeff \|/

Author

Commented:
Close, that closes the Access but the Scheduler Service still says "running" and looking under Task Manager I see that MSAcces.exe is still running, even though I don't see it. I click end task and the "running" status goes away.
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Top Expert 2006

Commented:
have u tried

application.Quit

there is DoCmd.Close but I think that still leaves access with no db open, still running

Author

Commented:
Running it from the batch file seems to work. Strange that would do it. Thanks Jeff. You are manxx.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.