Login X Data

[Guest]

My access db has a couple of users names that can view different kind of data from the same table

I would like to create an authentication to allow the user to access his own data. How can I do that

THX

 

[Joan Wild]

My access db has a couple of users names that can view different kind
of data from the same table.

I would like to create an authentication to allow the user to access
his own data. How can I do that?

THX

You can use the currentuser() function to get the currently logged in
username. Provided you have a field in the table to identify who 'owns' it,
you can set a criteria of CurrentUser()

 

[Guest]

The "currently logged in username" that you said refers to the Access DB User or the Windows user? I need the Windows user

TH

----- Joan Wild wrote: ----

Ricardo Contrucci wrote

My access db has a couple of users names that can view different kin
of data from the same table
his own data. How can I do that

You can use the currentuser() function to get the currently logged i
username. Provided you have a field in the table to identify who 'owns' it
you can set a criteria of CurrentUser(

 

[Joan Wild]

The "currently logged in username" that you said refers to the Access
DB User or the Windows user? I need the Windows user.

The Access username (your post said 'my access db has a couple of users
names'). If you want the network name, there is code at
http://www.mvps.org/access/api/api0008.htm
you can use to retrieve that.