[AccessD] Audit Trail Suggestions

[David Emerson]

Hi Team,

Looking for ideas for implementation.

Access 2010 FE, SQL 2008 R2

A client wants to keep track of some fields in some tables when they are
changed.  There are over 50 tables involved and anywhere from 3 to 30 fields
per table.  The tables and fields are predefined.  Most of the data changes
will be done via Access screens but there are some fields that are changed
through code

When a field value is changed they want to store in a log table date, person
making change, old value, new value.

Looking for ideas of how others might have tackled this type of problem
before.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand