[AccessD] Recording field changes

Some resources I found on Audit Tables (sorry, not much DAO/Access here):


MSDN Data Points

"Creating Audit Tables, Invoking COM Objects, and More"
By John Papa

http://msdn.microsoft.com/msdnmag/issues/04/04/DataPoints/default.aspx


MSDN

"Engine-Collection-Class, a Design Pattern for Building Reusable Enterprise
Components"

Mike McClure

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndevgen/ht
ml/desipat.asp


MSDN

"Designing Data Tier Components and Passing Data Through Tiers"

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/
BOAGag.asp



-Ken



-----Original Message-----
From: David Emerson [mailto:davide at dalyn.co.nz]
Sent: Monday, June 21, 2004 3:44 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Recording field changes


Group,

I have a client that needs to record all changes to the data on a field by
field basis (they don't want to record whole records if there is a change -
just the fields that changed (old and new values)).  My initial though is
to put code in every field that records the value on entry, compares this
on exit and records the change if they values are different.

Because there are several hundred fields involved I was wondering if there
was any easy way of doing the job without adding code to every field.

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (04) 478-7456
Mobile 027-280-9348