Can I capture the MS Access 'close event' during design
Posted on 2009-05-13
I am wanting to record in my DB every object's modified time-stamp when I close Access
Currently there is a bug in Access 2003 that doesnt update the MsysObjects table's "UpdateDate' for an object, but MSAccess does store a 'modified' date which is not accessible to the user via tables...only through code.
I believe I can iterate through forms, queries, reports, modules etc using the following line of code and a recordset out of MSysObjects
I will save the results to a table, but I want this to occur when I close Access.
I use this DB for design purposes only, it is linked to VSS and stores many objects which I then use to build custom applications by importing the objects I need into new databases.
The DB does not run a user application, so a hidden form is not the option.
Can I capture the closing event, and run my table update routine via VBA, before Access closes?