By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,652 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,652 IT Pros & Developers. It's quick & easy.

Trapping the Last record change date from a database

P: n/a
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,

--

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.