Audit Trail

  • Thread starter Thread starter DK
  • Start date Start date
D

DK

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
 
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/forum/forum_posts.asp?TID=399
http://www.rogersaccesslibrary.com/forum/forum_posts.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/wa.exe?SUBED1=ACCESS-L
 
Back
Top