recording which users modify records

[Satya Krishna Dasa]

does anyone know how to capture in a field of a table,
which user modified data?

 

[TC]

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