Per Tony Williams:
Does anyone know of an Access add in or routine that would work as an audit
trail? I want to be able to see which fields have been amended and when and
what the changed data was originally.
I've done it, but it wasn't trivial. Maybe greater minds than mine have come
with something more portable/easier to implement.
Before the user saves a record, I had to determine which fields were altered
(and not just entered/exited or over typed...) and then concoct something like a
"tblAudit" record and write it.
The approach I took was that when a user went into "Edit" mode on the screen, I
squirreled away a copy of all editable fields. Then, when the user clicked
"Save", I did a field-by-field comparison - writing an audit rec for each diff.
For portability, I chose to do recording on a field basis - one audit table
record per field changed and store the table name/field name/English-language
field name in the table.
