Quit Command Not Working

[bharlow]

I have built a process using task schedulers to run Access DB macros and then close the application with a Quit Command. If I am on the computer, testing the process, the task schedulers run perfectly and all macros run and the Access application is closed.

When the task scheduler process runs overnight for some reason all the macros run except for the Quit Macro. I have to close the DB's down each morning. It only takes a few seconds, but if I am not available the DB's stay open and this holds up the process for the next day.

Has anyone run into this problem or does anybody have any ideas what might be causing this odd scenario?

 

[MStef]

Look at "DemoAppQuitA2000.mdb" (attachment, zip).
Open Form1 and try.

 

[bharlow]

Thanks MStef

I'll give it a try. It will be tomrrow before I know if it gets around overnight issue.

 

[bharlow]

Mstef,

Thank you very much.

This has been working consistantly since we changed the close application process.