How do you implement an audit log in MS Access?
A Allen Browne Dec 24, 2004 #2 Access does not do this for you, but if you are comfortable with VBA programming and SQL statements, and all changes take place through the forms, you can achieve it through the events of the form. Details in: Audit Trail - Log changes at the record level at: http://members.iinet.net.au/~allenbrowne/AppAudit.html
Access does not do this for you, but if you are comfortable with VBA programming and SQL statements, and all changes take place through the forms, you can achieve it through the events of the form. Details in: Audit Trail - Log changes at the record level at: http://members.iinet.net.au/~allenbrowne/AppAudit.html
N Nick Coe \(UK\) Dec 24, 2004 #3 Is this what you mean? From Allen Browne's site: http://members.iinet.net.au/~allenbrowne/AppAudit.html
Is this what you mean? From Allen Browne's site: http://members.iinet.net.au/~allenbrowne/AppAudit.html
