Question about Table Date Time Stamps

[Guest]

Hi,

I have a question about the date time stamp for the tables.
I am looking at the "Table" tab under the "Objects" in the main view in
access.
There is a "Created" and "Modified" date. My question is when is created
and modified updated with a new date.

I ran a query that deleted table "XYZ" and then appended 3 tables to "XYZ"
but the "Modified" date did not change. Does this make sense.

Thanks for your help on this!

 

[Douglas J. Steele]

Those dates are intended to reflect when design changes are made to the
table (adding or removing fields, changing field names, adding or removing
indexes, etc.), not when data changes are made.

If you need to know when the data changed, you need to do it yourself.

 

[Tom van Stiphout]

On Tue, 13 Nov 2007 06:34:08 -0800, Jeff

Use precise language. You did not append some tables to a table, but
some records.
The datecreated and datemodified are for the table object, not for the
table data. There is no way to find out when data was last appended or
updated, unless you do the work yourself (e.g. LastModifiedDate
field).

The datemodified property at the table level may be updated when you
compact a table. For sure some other objects such as forms will update
their timestamp upon compact. This can be highly annoying.

-Tom.