Automate closing an Access 2003 database

[peter1952]

I would like to automate closing an Access 2003 database at the end of running a macro. How can I do this?

[kadghar]

if the VBA code is in access itself:

application.clo se

if you're using an ActiveX object from elsewhere (supose it's Obj1):

set Obj1 = nothing

that should do it.

[peter1952]

Thanks, I get the following error dialog box
---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

Method or data member not found
---------------------------
OK Help
---------------------------
?

[kadghar]

Sorry, my mistake. It should be something like

application.qui t

[peter1952]

Briliant, hat works.

Thank You