Tracking Recordset Changes

You may need to determine when the design of the underlying table of a table-type Recordset object was created, or the last time it was modified. The DateCreated and LastUpdated properties, respectively, give you this information. Both properties return the date stamp applied to the table by the machine on which the table resided at the time it was stamped.