userid on network recording on record in a table

28 May 2006 11:13 AM

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 ?

28 May 2006 11:28 AM

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)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Show quoteHide quote

"Ryno" <R***@discussions.microsoft.com> wrote in message
news:F7E67A93-9A99-47B4-A270-265712DCF2AF@microsoft.com...
>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 ?

28 May 2006 1:50 PM

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?

Show quoteHide quote

"Ryno" wrote:

> 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 ?

28 May 2006 4:36 PM

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Show quoteHide quote

"S Panja" <SPa***@discussions.microsoft.com> wrote in message
news:568C3AF0-C97A-476C-9701-224ABA72F94B@microsoft.com...
> 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?
>
>
> "Ryno" wrote:
>
>> 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 ?