Tracing Last User Who Modified a field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it poss to trace a modification to a field by a
particular user / workstation?

Any ideas would be greatly appreciated.

Many thanks in anticipation of a response.

Leon
 
Access/Jet doesn't support triggers (which would make this a trivial
exercise), so instead you must use events ... in the Before or AfterUpdate
Event of your form, you can log the Username and Date/Time (via the Now()
function) to a table, along with any pertinent information you wish to cull
from the record. You could do the same at field level by using the same
function for the Control (for example, a Textbox). You must have either (a)
enable Acces security (in which case you would capture user info via the
CurrentUser method) or (b) have a utility in place to cull the Network User
name to identify the person making the change (get code to retrieve the
Network stuff at mvps.org). It's a lot of work, as you must do this in every
instance where records are updated.
 
Back
Top