"date last modified" for table-content in ACCESS?

[Guest]

Apart from finding out when a table-design was last changed, is there
somewhere a record of the "date last changed" of the contents of an
individual table?

 

[John Vinson]

Apart from finding out when a table-design was last changed, is there
somewhere a record of the "date last changed" of the contents of an
individual table?

No, not unless you create a table with such a field yourself.

John W. Vinson[MVP]

 

[Sandra Daigle]

In each table where you want this information you have to add the field(s)
that you require. Then you also have to ensure that every form that allows
update to these tables also does the timestamping. I generally do this using
the BeforeUpdate event of the form - assuming you have controls for your
date and time fields:

me.LastModDate=date()
me.LastModTime=Time()

Note that you could just have a single date field which stores all of this
information - since the date datatype also includes time. Use the Now
function to pull date and time into the date field:

me.LastModified=now()

I also log the user name and rather than adding this code to every form, I
have a public function which I call from every form that requires this
functionality.