By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,805 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Help on tricky permission

P: 8
Hi, I need help on this tricky access permission issue:

For my database, I want to allow users be able to edit his/her records, insert new ones and review other user's records but no edit. How to set up the permission? BTW, I do have users ID in my database.

Thanks a lot for your help!
Dec 8 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,661
This won't be straightforward.
There are no separate permissions on records in a table.
If you must have it you'd need to design a whole interface to the table which would also need to include the owner user.
Each access to the table would have to be checked against the username.
Dec 8 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi, I need help on this tricky access permission issue:

For my database, I want to allow users be able to edit his/her records, insert new ones and review other user's records but no edit. How to set up the permission? BTW, I do have users ID in my database.

Thanks a lot for your help!
Each record would have to store the users ID and the record source of the editing and adding forms would have to be restricted to records corresponding to that users ID. For viewing other records the form could show all records but set the forms properties of Allow Additions, Allow Deletions and Allow Edits to No. You cannot mix the two in the one form.

Mary
Dec 9 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.