Exit Access

[vr]

I have a command button to exit Access97.

DoCmd.Quit

This closes the Access database, but not the Access application. In fact, I have to Alt Ctl Delete to end the application.

I have closed all of my ADO connections and recordsets.

Does anyone have any suggestions?

 

[tomschafer]

What about...

application.quit

 

[vr]

Thanks, I have tried this with no luck either.

 

[gyma]

I also experienced this undocumented feature.... My particular problem had to do with some code that was implied instead of being explicit .... can't remember the exact code .... check out this site:

http://www.mvps.org/access/bugs/bugs0005.htm

a lot of good stuff .... I think the site may also note the MS website (knowledge base)that gives MS's spin on the bug...
Hope this helps_

gyma

 

[Databaseguy]

I think Gyma is on the right track. Have you Automated Access from another Application ?? I.E., Word/Excel/Outlook.

If so, in your Code, make sure that at the end, you always include something like:

With ObjAccess
Application.quit
End With
Set ObjAccess = Nothing

This'll keep extra intances of Access from hanging around.
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy