Audit Tracking - Users

[fiona.innes]

Hiya,

Basically I have 2 tables tblEmployee and tblDetails. My database is a
shipping database that tracks all the freight in the warehouse.
Records are added by the guys in the warehouse and then edited by
staff in the office, therefore there will be multiple users of this
database. Need to devise somesort of tracking which records which user
has edited the record and what changes he/she has made. I have found a
great example which you have to add a field in tblDetails and set it
to memo and then attach some code in the beforeupdate event in the
form. This works really well but when you make amendments to the
record it always says user: Admin. How do you set up multiple users so
that it might say User: Warehouse, or User: Gemma etc...?

Fiona

 

[Allen Browne]

You can use an API call to Windows to get the user name (i.e. who is
currently logged in):
http://allenbrowne.com/ser-53code.html#GetNetworkUserName

 

[scott04]

Allen's code for getting get work user name works lovely. I can say that i
personally use it and it grabs the login and timestamps and lets you know if
its an edit insert or delete. Thanks for all your helpfull posts Allen

 

[Allen Browne]

Feedback appreciated.

I assume you were talking about this article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[scott04]

Yes that is the article

Feedback appreciated.

I assume you were talking about this article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html