userid on network recording on record in a table

[Ryno]

I need MS Access 2000 to record the userid on a network on record so that I
can trace who work on that record - .mdb file is shared on a shared harddisk
via network ?

 

[Douglas J. Steele]

Grab the code in http://www.mvps.org/access/api/api0008.htm at "The Access
Web" for how to determine the userid.

Put code in your form's BeforeUpdate event to modify the userid field on
your record. (In anticipation of your next question, you can only do what
you want if you're using forms to update your data)

 

[S Panja]

Using CurrentUser in the form will help track the user who created / modified
the record. Note that the network user may not be the database user.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

 

[Douglas J. Steele]

However, CurrentUser only works if you've applied Access User-Level Security
to the database and are forcing the user to log into the application, and
it'll only show you the Access userid, not the network userid.