Audit Trail in Access
Posted on 2005-05-06
What are some of the better ways to establish a simple audit log of what users change while editing data in an access table? Let's assume they will be doing so not directly in the tables but through a simple form which has your basic textbox data linked fields.
They will change something (anything0 and then either click the pencil or the save button and close the form.
I'd like this to somehow create an entry in a history table of this user it was and what they changed, so we could pull up a change history on any given record from that particular table.
Thank you in advance for your thoughts and knowledge sharing.