time stamp information in system table

[Guest]

I want to know the creation date/time of a record but the record itself does
not have a field to indicate when it is created.

Is the creation date/time is recorded somewhere in system tables of Access?
Is it possible to know it by exploring the data in the Access system tables?
If so, how?

Many thanks in advance.

 

[Rick Brandt]

I want to know the creation date/time of a record but the record
itself does not have a field to indicate when it is created.

Is the creation date/time is recorded somewhere in system tables of
Access? Is it possible to know it by exploring the data in the Access
system tables? If so, how?

Many thanks in advance.

No.

 

[Vincent Johns]

No.

You can probably get some idea based on when the database file was
created and when it was last modified (record creation would be between
those times).

For the future, you might accomplish this by adding a [DateModified]
field to the Table and setting the field's contents to Now() in the
AfterUpdate (or similar) event of the Form you're using to update it.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.