I am newb to this forum and MS Access. 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,...
User Profile
Collapse
-
MS Access User permissions
-
Captain u r quite right if the tables are normalized here. However i think that it would be jsut a simple query without join cuz in this way he will be able to get the data form both tables. If join condition is there then he will be getting only the common tuples from both tables. Just a clarification to your answer. I might be wrong here.
No activity results to display
Show More
Leave a comment: