[AccessD] Audit Trails

http://articles.techrepublic.com.com/5100-10878_11-6166807.html

Rocky, this will help get you started. Don't do a cut and paste from the web 
page -- that creates a mess. There should be a download with the code or an 
mdb file. Also, read the comments -- the readers often add little tidbits to 
make stuff even better or more efficient.

Susan H.



>
> I am developing an application where the user needs to record changes to
> fields in several tables - table name, field name, old value, new value,
> date/time of change, user name.
>
> What is the best approach to this?
>
> Is .OldValue available after the record has been updated?  If so I could
> loop through the bound fields checking for changes and add an audit trail
> record if changed.
>
> It would be nice to have this audit trail function packaged in one 
> function
> that could be called form anywhere in the app since several tables will 
> have
> the requirement.