Macro needed on close of database file

[stafire_18]

i need a code that will run a macro when the database is closed. if you have one, will this work if the "X" in the very top right hand corner is selected? or just if it's attach to a command button? Right now i have this macro as an autoexec but found some errors when multiple users open up the mdb.

 

[VicRauch]

If you open a form that is hidden when the database opens, then as the database is closed, that form will be closed, thereby giving you (your application) that the database is closing. If you need to keep tract of how many people are signed on to the database, then you can keep count in a table as the form is opened and as it is closed. When closing and the table shows this to be the last person signed on, do whatever it is you need to do.
HTH

 

[VicRauch]

A little more info in case you need it about multiple people being signed on at the same time. This was supplied by CT Witter in this thread

Check out these Microsoft KB Articles, depending on your Version:
2000
How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000
http://support.microsoft.com/kb/198755

XP(2002) or 2003:
How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2002 or in Access 2003
http://support.microsoft.com/kb/285822

HTH,
CT