Is there a way to set up an audit tracking in Access?

[Guest]

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

 

[Tony Toews]

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

 

[hireagenius via AccessMonster.com]

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