J
Jay
I have searched the forum before posting this message. I
have even searched other forums also. I am not sure if I
used the right keyword to search for this topic.
I apologized for posting a long message.
We have split MS Access application. A user wants to
implement security that a user from one group cannot
UPDATE or DELETE the record created by a user from another
group in the department, but can view a record created by
another group.
I don't think this can be implemented using MS Access
security without creating additional tables and code. I
just wanted to make sure that I am correct on my thinking
before proposed a solution which will require making lots
of changes to the application. I had the following
thoughts in mind on how to do this:
1. A table to store dept. Also AutoNumber to create a
dept #.
2. A table to store user name, dept #, effective date and
end date. End date NULL or in future.
3. A form to setup a user or move a user between the
groups.
4. Add a column to store the dept # of the user name who
created the record in each table or tables which stores
the data to be protected.
5. Add function to open the form in Read only mode or Edit
Mode depends on who created the record and who is trying
to retrieve the record.
Thanks
Jay
have even searched other forums also. I am not sure if I
used the right keyword to search for this topic.
I apologized for posting a long message.
We have split MS Access application. A user wants to
implement security that a user from one group cannot
UPDATE or DELETE the record created by a user from another
group in the department, but can view a record created by
another group.
I don't think this can be implemented using MS Access
security without creating additional tables and code. I
just wanted to make sure that I am correct on my thinking
before proposed a solution which will require making lots
of changes to the application. I had the following
thoughts in mind on how to do this:
1. A table to store dept. Also AutoNumber to create a
dept #.
2. A table to store user name, dept #, effective date and
end date. End date NULL or in future.
3. A form to setup a user or move a user between the
groups.
4. Add a column to store the dept # of the user name who
created the record in each table or tables which stores
the data to be protected.
5. Add function to open the form in Read only mode or Edit
Mode depends on who created the record and who is trying
to retrieve the record.
Thanks
Jay