how to determine last time database object was opened?

[leeroi]

Is there a way to determine the most recent date that a local database object (table, form, etc.) was opened? "Created" and "Modified" do not give me the information I need.

Lee

 

[mp9]

DateCreated and DataModified are the only timestamps stored in MSysObjects. If you need to capture the date opened you need to create a table with ObjectName and OpenTimeStamp and then write to it programmatically every time an object is opened. This might be very hard to enforce if your users have access to the database window and so can open objects directly rather than from a form, menu or toolbar.