|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Is there a way to set up an audit tracking in Access?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 <S**@discussions.microsoft.com> wrote:
>Is there a way to take the user name from the access security feature and There's a simple example at >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 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 Sal wrote:
>Is there a way to take the user name from the access security feature and Sal,>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 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 
Other interesting topics
Permissions Help
Unsecuring a secure Access Database? Providing logins for users and filtering records based on users Backend DB Password digital signature trouble access security Allowing only certain users to view design and code Text box Creating MDE Stalling Prohibitting users from browsing table |
|||||||||||||||||||||||
