-
User permission -- Help plz
I am just wondeing if someone can help me with the read, write, update, delete permissions. I know you can do it using a wizard in MS Access, but its not an efficient way of doing things.
I have created a login table
EmpID Permissions
1234 Read
1235 Write
1236 Update
1237 All
Now whenever an employee want to insert, delete, read or update something in a table i want to check his permission level from the login table before giving him access to the table.
How would i do that on database level without using the wizard?
Can we create triggers in MS Access too. If no is there is a work around?
-
Generally speaking, if all access to tables is through forms, then it is easist to control the type of access you grant a user by granting them their type of access with the form.
So, if a user only has Read permission, then you could change the form's properties to disallow Update, Add, and Delete. You would not be able to only allow someone Write permission, unless you mean Add, then you can restrict to only allowing the addition of records. Update is the same, you can allow Update without Add, but of course you can not disallow Read if they have Update.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|