I have a question and hope to get an answer from you. I have created a database with user names and passwords. Basically, all users can have access to the records (the way I set it up). Is there a quick and dirty way to log the name of the user who changes any field in a record? I don't care what the change is, I just want to know that there was a change made by a user. I have watched your Access Security Seminar and you have showed how to log activities of users for each filed. But is there a way to just check all of the fields of a record? Thanks a lot!

---

Reply from Alex Hedley:

You could use a combination of the BeforeUpdate event and the .oldValue property to check for changes and log them.