Track User Changes

[watchingusers]

I need something that on After Update of a Form the users
changes are flagged and a date gets attached to the
record.
This way I can look at the tables and see what
information has been changed in the form, when it was
changed and how many times the it was changed.

Using 2003.

 

[Allen Browne]

Big question. Especially if you want to log deletions as well.

For a discussion of how and the code you need, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[TC]

You'll have to code it manually.

Add a DateLastUpdated and NumberOfTimesUdated fields to the table in
question. In the forms BeforeUpdate (not AfterUpdate), set the former to
today's date (Date()), and add 1 to the latter. That gives you those two
values very easily.

As for knowing what actual values changed, perhaps have form AfterUpdate
(not BeforeUpdate) to save a copy of the new record to a seperate table.
Make sure to handle duplicates, if the user edits the same record
repeatedly, in a short period. Then you can sort the records in that table
by PK + date/time, to see the histry of changes to each record.

HTH,
TC

 

[___]

Here is a good example.

HT

+----------------------------------------------------------------
| Attachment filename: audit trial a2k.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=157769
+----------------------------------------------------------------