Limit user to only records with his/her ID

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

Is there a way that I could limit users to only see and
change data/records with his/her own ID? I would also
need for people in my manager and admin groups to have
rights to see/change all records.


Thanks
 
Hi Allie,
Is there a way that I could limit users to only see and
change data/records with his/her own ID? I would also
need for people in my manager and admin groups to have
rights to see/change all records.
Click to expand...

You could need to implement user level security, and then use the
CurrentUser() function to retrieve the current user's Access login name (you
could set this as a criteria in a query, provided you have a field in each
record that stores the 'owner' of the record).

Download and study the security FAQ. Follow every step outlined. There is
also sample code in the FAQ you can use to determine if a user is a member
of a group.
http://support.microsoft.com/?id=207793
 
Back
Top