Audit on Access

[Billy]

Hi People,
I am wondering if there is a way to audit access database and be able
to track down who used the database, what changes were made and the
time changes were made. This is a feature in many database
applications and I am wonder if this can be done in Access. I know you
can check who is logged in.
Anybody please advise
Billy

 

[Joan Wild]

You can only do this if you've set up the necessary code/tables to track it
beforehand.

See Creating an Audit Log
http://allenbrowne.com/AppAudit.html

I'm not positive that URL is correct, but you'll find an audit trail sample
somewhere on Allen's site
www.allenbrowne.com

 

[Billy]

Thanks a lot Joan, you have been of great help. The coding on that URL
look overwhelming but, I will try it out and see what I come up with.
I am glad I can do this.
Billy