Hi Everyone,
Does anyone know if there is a way that if user1 signs in and adds data to the database, then user2 signs in and adds data, can I track who has added what to the database?
I am using Access 2003.
Thanks
Neil45156
Hi Everyone,
Does anyone know if there is a way that if user1 signs in and adds data to the database, then user2 signs in and adds data, can I track who has added what to the database?
I am using Access 2003.
Thanks
Neil45156
That is called an Audit trail. Sometimes it is refered to as maintaining a history of changes.
Here is three examples to look at:
Rogers Access Library:
AuditTrail.mdb ( intermediate )
http://www.rogersaccesslibrary.com/forum/topic399.html
AuditTrail2.mdb ( advanced )
http://www.rogersaccesslibrary.com/forum/topic398.html
The Access Web:
Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm