time stamp information in system table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Newbie said:
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.
Click to expand...

No.
 
Rick said:
No.
Click to expand...

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.
 
Back
Top