[AccessD] Audit Trail Suggestions

[jack drawbridge]

David,

Here is another for consideration/review
http://www.utteraccess.com/forum/Audit-Trail-Database-S-t1576962.html

jack

On Sat, Mar 14, 2015 at 8:26 AM, jack drawbridge <jackandpat.d at gmail.com>
wrote:

> You  may get  ideas from Allen Browne's site.
> http://allenbrowne.com/appaudit.html
>
> Good luck.
>
> On Sat, Mar 14, 2015 at 12:21 AM, David Emerson <newsgrps at dalyn.co.nz>
> 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
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>