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.

No.
 
Rick said:

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top