Audit Trail

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
 
R

Roger Carlson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top