Microsoft Access Database: Creating an Audit Trail in Microsoft Access

Some Microsoft Access database systems require an audit trail feature built to track the movement of sensitive records that administrators need to monitor and control data processing tasks.

I found this article from a popular database solution resource which is for the more advanced Access database developer but it’s the only way I know of how you create such a feature and it does require some VBA code too.

Microsoft Access Database – Article on How to Create an Audit Trail

Click here to view the article

If you wish to know more about VBA code and programming in Microsoft Access, then contact me for further help.

I would like to know if you have had any experience with this sort of feature and have perhaps found another to achive this – please post your comments!

This entry was posted in Forms, Modules, MS Access, Utilities, VBA and tagged , , , , . Bookmark the permalink.

2 Responses to Microsoft Access Database: Creating an Audit Trail in Microsoft Access

  1. fast weight loss says:

    It is actually a great and helpful piece of information. I’m satisfied that you shared this useful info with us. Please keep us informed like this. Thanks for sharing.

  2. Ben Beitler says:

    Another tip for you! Add a date and time stamp field and modify the VBA code by adding the NOW function which captures the current date and time. Make sure a field is created in the table and you have modified the SQL statement in the code too.
    Want to know how? contact me.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.