|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Audit TrailIs 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/forum/forum_posts.asp?TID=399 http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=398 -- Show quoteHide quote--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 "DK" <D*@discussions.microsoft.com> wrote in message news:4CCEB5FF-C972-4A07-BB36-6CE7CBFC25B8@microsoft.com... > 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 Show quoteHide quote "DK" <D*@discussions.microsoft.com> wrote in message news:4CCEB5FF-C972-4A07-BB36-6CE7CBFC25B8@microsoft.com... > 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 |
|||||||||||||||||||||||