Is there a way to constrcut and audit for changes made to records? The audit
trail would include who made the change and what date and time it was last
updated.

Thank you
--
Dave

On my website (www.rogersaccesslibrary.com), are two small Access databases
sample called "AuditTrail.mdb" and "AuditTrail2.mdb" which illustrate how to
do this. AuditTrail is simpler, so you might want to start with that.

You can find them here:
http://www.rogersaccesslibrary.com/f...ts.asp?TID=399
http://www.rogersaccesslibrary.com/f...ts.asp?TID=398

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"DK" <(E-Mail Removed)> wrote in message
news:4CCEB5FF-C972-4A07-BB36-(E-Mail Removed)...
> Is there a way to constrcut and audit for changes made to records? The
> audit
> trail would include who made the change and what date and time it was last
> updated.
>
> Thank you
> --
> Dave

take a look at http://allenbrowne.com/AppAudit.html

hth


"DK" <(E-Mail Removed)> wrote in message
news:4CCEB5FF-C972-4A07-BB36-(E-Mail Removed)...
> Is there a way to constrcut and audit for changes made to records? The
audit
> trail would include who made the change and what date and time it was last
> updated.
>
> Thank you
> --
> Dave