Is there a way to set up an audit tracking in Access? Sal 05.07.2006 22:31:01 Is there a way to take the user name from the access security feature and hand it to a field in a db in order to know who posted a record? Audit tracking by user is basically what I mean. Let me know. Thanks

Re: Is there a way to set up an audit tracking in Access? Tony Toews <ttoews[ at ]telusplanet.net> 06.07.2006 03:34:37 Sal <Sal[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Is there a way to take the user name from the access security feature and >hand it to a field in a db in order to know who posted a record? Audit >tracking by user is basically what I mean. Let me know. Thanks 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://allenbrowne.com/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

Re: Is there a way to set up an audit tracking in Access? "hireagenius via AccessMonster.com" <u13998[ at ]uwe> 06.07.2006 16:14:18 Sal wrote: [Quoted Text] >Is there a way to take the user name from the access security feature and >hand it to a field in a db in order to know who posted a record? Audit >tracking by user is basically what I mean. Let me know. Thanks Sal, Create a field in your database and set =CurrentUser() the default value. Charlie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200607/1