MSACCESS Remains in TaskMgr after Exit

[JasonRkr]

Hi, all.

I'm new to all of this so please bear with me.

I'm setting a scheduled task to run a macro from an Access 2007 database (actually Access 2007 linked to an Intersystems Cache database). When I run it the report is displayed as desired and the window closes, but in Taskmgr MSACCESS.exe is still running. How do I get it to exit?

Please let me know what additional details would help resolve this.

Thank you.

Jason

 

[SimonB1978]

Hi,

How does the window closes? The user clicks the "X" in the report? If so you can add "Docmd.Quit" to the report Close() event.

Simon B.

 

[JasonRkr]

SimonB1978, thanks for the quick response. As this runs as a Scheduled Task, there is no user interaction. I just need it to completely close after running.

 

[SOS]

Put

Application.Quit

into the code at the end of whatever you are doing (or if using macros include a line to do the same at the end of it)

 

[JasonRkr]

SOS,

Thanks, that did the trick. Strange though, they already had the following and it didn't work.
Function QuitDB()
On Error Resume Next
Quit
Exit Function
End Function

I changed it to Application.Quit and it did. Gotta love it.

Regards,

Jason

Put

Application.Quit

into the code at the end of whatever you are doing (or if using macros include a line to do the same at the end of it)

 

[SOS]

Glad to hear that helped.