6. Data > 6.1. Save with Each Record the Name of the Last Person Who Edited It ...

6.1. Save with Each Record the Name of the Last Person Who Edited It and the Date and Time

Problem

Your application is used in a
multiuser environment with users regularly adding and editing
records. Access keeps track of when an object was created and last
modified. However, it does not track this information at the record
level. With each record, you want to log who created the record, who
last edited the record, and the date and time associated with each of
these actions. Is this possible?

Solution

Access has no built-in feature that records who edited a record and
when the edit was made, but it’s fairly easy to
create your own. You’ll need to add four fields to
each of your tables to hold this information. You’ll
also need to create two simple procedures and attach them to the
BeforeInsert and BeforeUpdate events of your forms.