Help with user level security

  • Thread starter Thread starter noe1818 via AccessMonster.com
  • Start date Start date
N

noe1818 via AccessMonster.com

I want a user to have the ability to enter and edit only one record. (not be
able to see other records).

We deal with clients here. A client is going to be give access to certain
forms. I want them to be able to use "find record", type in their id and have
their record come up. Then they would be able to enter data or edit it (not
delete it), but I don't want them to be able to view other clients data. Is
there a way to give edit and add abilities without allowing them to view
other records, while still having the ability to use the "find record" button
I created?
 
You don't need user level security to do that, but it can be done that way.
I'd build a database that only allows a single form with edit only
permissions. Create an MDE, so the users can't change the form properties.
Now you can use user-level security, or you can use a custom lookup to a
table, preferably a hidden table, or you can use the windows login username
api to recognize the user and do the lookup. The api code is at:

http://www.mvps.org/access/api/api0008.htm
 
Back
Top