Audit Tracking - Users

  • Thread starter Thread starter fiona.innes
  • Start date Start date
F

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'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
 
Back
Top