Limit user to only records with his/her ID

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
 
J

Joan Wild

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Providing only read/view permission of the email account to the user. (like Senior wants PS to only view his emails and not to respond or do action) 0
Please help me choose a product for the task 2
Using @ in comments: is there a way to get only one email? 0
Grouping Names in Mail Merge 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Access 2003 allowing users to view only certain records 6
Copy previous record into form field 0
Merging from an Excel file with graphics 1

Top