Force Access to Close All

[SmokingCrater]

Does anybody know of a command (VB, Macro, or otherwise) that I can use that will force a close of Access? I need it to force the close through any data objects that may be remaining open. i.e. the force must close any objects as well as the database. I had been using Application.Quit but that does not close any open objects and Access just gets minimized to the taskbar, it does not get closed. The problem I am having is that a hidden object is getting created (I am not creating the object) and therefore Access is not quitting.

I had been using the ExitProcess function found in the Kernel32.dll however the problem with that is the .ldb file is not deleted and my client desires to have that file disappear. Any help would be great.

Thanks.

 

[DougP]

IN VBA
END

in a Macro
"Quit" DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[JaneInMA]

try this code from access web
Dim intx As Integer
Dim intCount As Integer
intCount = forms.Count - 1
For intx = intCount To 0 Step -1
DoCmd.Close acForm, forms(intx).Name
Next
DoCmd.Quit
Cycles through the active forms closing them then closes the application.