In addition to the properties listed as new to Access 2002, two other properties are worth mentioning. They are the DateCreated and DateModified properties. They are available for
all Access objects. Here's an example that shows the use of these properties with the AllTables collection:
Public Sub GetDates() 'Declare looping variable Dim vnt As Variant 'Loop through each table in the database 'referenced by the CurrentData object With CurrentData For Each vnt In .AllTables 'Print the name, date created, and the date the table was last modified Debug.Print vnt.Name & ", " & _ vnt.DateCreated & ", " & _ vnt.DateModified Next vnt End With End Sub
This code loops through each table stored in the database referenced by the CurrentData object. The name, creation date, and last modification data are all printed to the Immediate window.