Permissions for certain records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My employee database contains ALL information about ALL our employees. As our
employees are our product (for lack of a better word), there is a lot of
information in each record. But, I need to block most users from being able
to view the vice presidents' records. There are a few of these and They do
not wish other employees to be able to see them. How can I set those few
specific records ONLY with a password or something similar??

Kind regards
Rigby
 
rigby said:
My employee database contains ALL information about ALL our employees. As
our
employees are our product (for lack of a better word), there is a lot of
information in each record. But, I need to block most users from being
able
to view the vice presidents' records. There are a few of these and They do
not wish other employees to be able to see them. How can I set those few
specific records ONLY with a password or something similar??

Kind regards
Rigby
Click to expand...

There are probably various ways you could do it, one would be to have a
yes/no field in the table to which only "super users" have update access.
You could then test the contents of the field in the form's current event
and block access accordingly depending upon what's returned by the
CurrentUser method.

HTH - Keith.
www.keithwilby.com
 
Assuming you have a field called Rank, you can define a query - where
Rank<>VP - for the majority of your employees [Group 2 in user level
security]. For other employees [Group 1] do not write Rank<>VP in the query
so that they have access to records of all employees.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
 
Back
Top