How do I set up Access 2010 so that when a user logs in I can track the changes that he/she makes in the database? I have both local and linked tables.
Thank you!
How do I set up Access 2010 so that when a user logs in I can track the changes that he/she makes in the database? I have both local and linked tables.
Thank you!
Do you mean changes in data? Review http://allenbrowne.com/AppAudit.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
This tutorial by Denis Wright may be of some help.
http://www.datawright.com.au/access_..._in_access.htm
Thank you. Those are both very helpful. However, I don't understand how to tell the system the username. I don't want to add a username field to the top of each form. I'd rather have the user log in and have the system remember that information. I don't see how to handle that in either example. I'm building a multi-user database, so the function needs to handle multiple users being logged in at the same time. What's the best way to approach this? Thank you again!
when you use the VBA variable Environ("UserName"), the system grabs the username from the Windows System. This is the name associated with the Windows login.