[AccessD] Audit Trails

Thanks - that looks like the guts of what I need.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Saturday, July 18, 2009 11:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [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.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com