Trapping the Last record change date from a database

[Gerry Abbott]

Hi all,
Is there a convenient way to trap the date/time of the last change to the
data (in the tables) in a database.
(the date modified changes when the file is accessed, irrespective of
changes, so that's of little value)

Thanks,

--

[Lumpierbritches]

You might want to look at the Me.Dirty method for creating an update in your
db.

Use a hidden date field and the Me.Dirty value to update. If you use user level
security you can also log what user made those changes.

[Gerry Abbott]

Sounds like I've got to check every location where a record may be changed ?

Is this information not kept in a system or log table within the database ?

Gerry Abbott

"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m07.aol.com...

You might want to look at the Me.Dirty method for creating an update in
your
db.

Use a hidden date field and the Me.Dirty value to update. If you use user
level
security you can also log what user made those changes.