microsoft access audit log table

sxxgupta
sxxgupta used Ask the Experts™
on
Does any expert have example of access databases that can perform a running audit log of record edits, deletions, and insertions in a given table(s)?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
I would like to also be able to get the user name of the person logged.  The user name is the name a person uses to log into their windows pc and if possible the IP address of the PC.
Top Expert 2016

Commented:
just follow the instructions from this link

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

Author

Commented:
yes got it working.  Is there a way to capture the IP address of the PC?
Top Expert 2016
Commented:
see this link
http://www.mvps.org/access/api/api0067.htm

and pls. next time avoid posting more than one problem per thread. There is a rule here one question per thread. It is to your advantage since many experts will see a fresh question and you will get an answer faster.

Author

Commented:
Ok, capricorn, I have a followup question.  Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial