how do I restrict the information to the current network user

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ahmed - 19 Apr 2005 09:24 GMT

I am trying to link the database to the net work, I need to use the benefit
of using the user name as filter to restrict the information accessed by the
database user. in this case I will not have to creat a form asking the user
to logon or even I don't have to activate the database security.

basecally how can I retrive the network username and use it in the access
database?

Please help

Reply to this Message

Nikos Yannacopoulos - 19 Apr 2005 10:13 GMT

Ahmed,

The "quick & dirty" way is to use function Environ("Username").
The "poper" way is to use an API call, look at:

http://www.mvps.org/access/api/api0008.htm

The former is considered less secure in that environment variables are
subject to change by the user; in reality, though, I haven't come across
a user who new how to do it, so to me it's not a real issue. The choice
is yours.

HTH,
Nikos

> I am trying to link the database to the net work, I need to use the benefit
> of using the user name as filter to restrict the information accessed by the
[quoted text clipped - 5 lines]
>
> Please help

Reply to this Message