Trigger macro by opening access

[Lloyd Blankfein]

Hi,

I need to write a log-file to monitor the user activity in a database. This will be the design of the according log-file:

User | Date | Open / Close ?

Every open / close of the db triggers a log-file recordset.

My question is: Is there an vba-access-command (like WorkBook_Open in vba-excel), that triggers a macro by opening / closing the database?

Thank you very much,
Lloyd

[alansidman]

Look at this:

http://office.microsoft.com/en-us/ac...010336239.aspx

[Lloyd Blankfein]

Thank you very much for your fast reply!