• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint