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
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!