View only specific records in a table

J

Jonathan Brown

I've built a small contact management database of about
130 users. I want to allow these users to modify THEIR
OWN information. I don't want any user to see any record
that is not theirs. Is there a way to setup permissions
for a specific user to see only one record?
 
J

Jack MacDonald

Yes
You will need to add a "user" field into your database. Then use the
CurrentUser() function to a) populate the datafield and b) restrict
the queries to the appropriate records.

A step beyond that is to use Read With Owners Permission Queries to
prevent users from opening the tables directly, but instead to gain
access only via the RWOP queries. It is explained in the security FAQ
and you can find a link in my signature.


I've built a small contact management database of about
130 users. I want to allow these users to modify THEIR
OWN information. I don't want any user to see any record
that is not theirs. Is there a way to setup permissions
for a specific user to see only one record?
Click to expand...


**********************
[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Top