Can I capture the MS Access 'close event' during design

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

      CurrentDb.Containers(strObject).Documents(strObjectName).LastUpdated

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?
Milkus1Asked:
Who is Participating?
 
thenelsonConnect With a Mentor Commented:
The only way to capture MS Access closing is to have a form open (it can be open hidden) and capture its closing event. The form will close just before the DB closes.
0
 
Milkus1Author Commented:
Not really the answer I was seeking, and just reiterated what I said i didnt want...prefer no answer if this is the case
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.