Good morning. I am attempting to create an audit capability within a few MS Access tables. By this I want to have two fields on each record (EDIT_DT and EDIT_BY) auto-stamped each time the record is added or edited. In SQLServer I would create a trigger to do this. What are my options in Access? I think with EDIT_DT I can just have the field set to default Now(), right? How can I capture the user, is there a variable that has the users ID that I can default into EDIT_BY? Any help would be appreciated. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TRIGGER TYPE ACTIVITY 1
- Thread starter PrgrmsAll
- Start date
-
1
- #2
ZmrAbdulla
Technical User
See AuditTrail Db at
________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials
________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question