How do you make an audit record of all actions in Access?

[KarenBe]

Hello everyone,



Can anyone tell me if there is any way you can log all activity on a database for auditing purposes? You can do this in other packages but I am not sure how to do it in Access? Many thanks in advance, Karen

[mike60smart]

Hi Karen

If you Google "Audit Trail in Access" you will find lots of references

[KarenBe]

Many thanks Mike. :-)

[June7]

If by 'activity' you mean data changes, here is one commonly referenced http://allenbrowne.com/AppAudit.html

[orange]

Karen,
You might find this thread relevant. It would be helpful if you would describe what exactly is involved/expected in your
"auditing purposes".