Tracking Data

[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

[ssanfu]

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