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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a log of when a user made a add/modify/delete 2
Stopping 2 users from modifying the same record 1
Field Level 2
Access How to record date/time when specific field is modified in Access 2007 0
Access - permission to change by record 1
Capture NT username 4
Password protect a form record? 1
Access 2007 can't save record 1

Back
Top