Access Shell Window gets left open after application.quit

[Guest]

I've checked all my open and load events of every form in my application, I'm
not leaving any recordsets open.

So what would cause the following code to leave the Access shell open
After it shuts down the database and forms?
====================================
If MsgBox("Are you sure you want to quit?", vbYesNo + vbQuestion, "Quit?") =
vbYes Then
Application.Quit
End If
'====================================

 

[Allan Murphy]

Try this code

If MsgBox("Are you sure you want to quit?", vbYesNo + vbQuestion, "Quit?") =
vbYes Then
DoCmd.Quit acSave
End If

 

[Van T. Dinh]

Dirk Goldgar did a bit of experimentation with this and he concluded that
DoComd.Quit works more reliably than Application.Quit.

Suggest changing to DoCmd and see if it makes any difference.

 

[Guest]

That worked ... thanks!

Dirk Goldgar did a bit of experimentation with this and he concluded that
DoComd.Quit works more reliably than Application.Quit.

Suggest changing to DoCmd and see if it makes any difference.

 

[Van T. Dinh]

You're welcome ... and the credit goes to Dirk also.