recording which users modify records

  • Thread starter Thread starter Satya Krishna Dasa
  • Start date Start date
S

Satya Krishna Dasa

does anyone know how to capture in a field of a table,
which user modified data?
 
You would need to do several things.
- define a field in each table to hold this information;
- establish Access "user level security" so each user is required to log-on
with a valid username & password, then
- write a BeforeUpdate event procedure for each form, to copy the value of
the CurrentUser(0 function into the new field of the table.

HTH,
TC
 
Back
Top