Tracking Modification Dates

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?
 
A

Allen Browne

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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top