[AccessD] Audit Trail Suggestions

[John W. Colby]

I wrote a class set to handle this.  Feed in the control to the class 
and then watch the events.  Log changes.

John W. Colby

On 3/14/2015 12:21 AM, David Emerson wrote:
> 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
>
>
>