Logging Changes by User

[Ben]

Is there a way to log the windows User Name of the last
person to update data in a table? I have a "not me"
bandit who keeps screwing up data in the database and I
want to see who is being so careless. Or, be reassured
that the computer gnomes are in fact changing data.

Thanks if anyone has any information.

 

[Douglas J. Steele]

Yes, if you only let them update through forms.

Add an UpdatedBy field to your table, grab the code from
http://www.mvps.org/access/api/api0008.htm and put code to set the UpdatedBy
field to fOSUserName() in your form's BeforeUpdate event.