 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / November 2004Need to tell who last updated a record
I have a db which is used by 3 or 4 over a NT/2000 platform, I have set up the users by the security wizard and split the db into front and back. The db holds some 9000 records and basically I want to know who last updated them, I can add a last update date so I can tell when say record 5000 was last updated but I want the user name to show as well. Do a search. This is asked and answered all the time. Earlier today I a saw a post about timestamps. SERACH BEFORE POSTING PLEASE. > I have a db which is used by 3 or 4 over a NT/2000 platform, I have set up > the users by the security wizard and split the db into front and back. The db > holds some 9000 records and basically I want to know who last updated them, I > can add a last update date so I can tell when say record 5000 was last > updated but I want the user name to show as well. Do a search. This is asked and answered all the time. Earlier today I a saw a post about timestamps. SEARCH BEFORE POSTING PLEASE. > I have a db which is used by 3 or 4 over a NT/2000 platform, I have set up > the users by the security wizard and split the db into front and back. The db > holds some 9000 records and basically I want to know who last updated them, I > can add a last update date so I can tell when say record 5000 was last > updated but I want the user name to show as well. >I have a db which is used by 3 or 4 over a NT/2000 platform, I have set up >the users by the security wizard and split the db into front and back. The db >holds some 9000 records and basically I want to know who last updated them, I >can add a last update date so I can tell when say record 5000 was last >updated but I want the user name to show as well. One method is to add a userid, workstation and date/time to every table and record in the beforeupdate event these values. You can use the audit trail logic as a guide to get you started. There's a simple example at ACC2000: How to Create an Audit Trail of Record Changes in a Form http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592 Audit Trail - Log changes at the record level at: http://members.iinet.net.au/~allenbrowne/AppAudit.html The article addresses edits, inserts, and deletes for a form and subform. Modules: Maintain a history of changes http://www.mvps.org/access/modules/mdl0021.htm The History Table routine is designed to write history records that track the changes made to fields in one or more tables. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.