Tracking Modification Dates

  • Thread starter Thread starter dpdeleon
  • Start date Start date
D

dpdeleon

Does anyone know if Access keeps track of modification dates to forms,
reports, tables, etc?

If so, is there any way to extract the information?
 
Access does track the Date Created and Last Updated dates for the various
objects. You can see these in the Database window if you select Details from
the View menu.

You can also access the properties programatically, e.g.:
CurrentDb().TableDefs("MyTable").LastUpdated
or as a query:
SELECT Name, DateCreate, DateUpdate FROM MSysObjects
WHERE Type = 1 ORDER BY Name;
 
Back
Top