how do I restrict the information to the current network user

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

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

Ahmed wrote:
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