Can this be done in access and where can i find information on how

[Bruce]

Is it possible to track changes to individual records in a database?

I would like to track changes made to any field in any record.

The time the change was made.

What assigned user made the change?

Also the database needs to be accessible to multiple users simultaneously.

Is this possible?

Bruce

 

[PieterLinden via AccessMonster.com]

Is it possible to track changes to individual records in a database?

I would like to track changes made to any field in any record.

The time the change was made.

What assigned user made the change?

Also the database needs to be accessible to multiple users simultaneously.

Is this possible?

Bruce

It's somewhat painful in Access because it traps form-level events, not table-
level events (like you can do with triggers in SQL Server), but Allen Browne
has an example here:

http://www.allenbrowne.com/AppAudit.html