How can I run code every time the database is closed or exited? 3

[kbdci]

I would like to run code to copy my .mdb backend files when a user closes the database or exits Access. I can't find any way to kick off the code. Can anyone help?

Thanks.

 

[ssatech]

How's it going kbdci,

Check out:

Thread705-490909 something you might be looking for..

Or here's a few:

Thread181-767477
Thread705-685036
Thread181-553541
Thread181-514192
Thread705-513841

 

[LittleSmudge]

Do you have something like a MainMenu form that stays open for the entire life of the database ?

If so use that

Otherwise - when the database first open have a special form that opens hidden - so the users don't see it.

Then in whichever of these you go for put some code in the Form_Close event that runs the code you want.


'ope-that-'elps.


G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[JeremyNYC]

What LittleSmudge says.

---
Jeremy Wallace
METRIX Lead Developer
Fund for the City of New York
http:// metrix . fcny . org

 

[kbdci]

Thanks for the suggestions. I was hoping for a more direct way to do this than to use a hidden form but that will work. ssatech - How can I find the threads you suggested? I tried searching on the number, but nothing was found. Thanks again, all.