Terminating an Access Application?

[blakemckenna]

What is the best way to safely terminate an Access application thru VBA code?

Thanks,

Blake

[RobDog888]

If its opened through VBA then is there another DB thats open too? How did you open the db from VBA when you need to
have a db opened first?

[Hack]

What is the best way to safely terminate an Access application thru VBA code?

Thanks,

Blake

Are you talking about safely closing or abruptly terminating?

If you are talking about abruptly terminating, then I assume you will be running Access VBA code from one database, but wanting to terminate the running instance of another database, correct?

[blakemckenna]

When my Access app is finished processing all of the code....the very last thing I want to do is end the application. I tried doing this with the "End" command and it comes back with a window in which I need to select "Halt". When I use the myApp.Quit object, my program seems to loop. How should I handle this?

Thanks,
Blake

[RobDog888]

You need to close all recordsets (if any) and set to nothing. Then close any connection objects and set to nothing. Then close the
db using the AOM.

[blakemckenna]

What is AOM?

[RobDog888]

Access Object Model

[blakemckenna]

Rob,

What is the syntax for closing the AOM?

Thanks,

Blake

[RobDog888]

Should be something like I described and ..

'Close and destroy all your other objects.
'Then...
oApp.CloseCurrentDatabase
oApp.Quit
Set oApp = Nothing

[blakemckenna]

Cool...

Thanks Rob!!!

[RobDog888]

No prob, but note that the oApp object is your variable object that you created when you opened the db if you did it that way.
Else its just the Application object.