security

[Guest]

I have a database.I need to create several logins and two master logins in
such a manner that none of the users would be able to view each others
data,but the two master users can view everyones data.I have added a field
say EID to each table to identify who owns it and also set control bound to
currentuser() in the forms.I have also changed the record source of
forms/reports to queries(currentuser()).But i am unable to accomplish my
task.Is there any other solution to my problem.Please provide me better
solutions for my problem.
Thanks

 

[Rick B]

What do you mean, " I am unable to accomplish my task"?

It sounds like you are pretty much there.

Did you take away the users' access from the tables completely? Are your
queries set to run with owner permission? Have you created a separate form
for your master users and only given them access to it? That would be one
way, another would be to include "If" statements in your queries to pull all
records if the signed on user was one of the masters.

Lots of ways to go, but you never told us why you are not able to get it to
work. You started out giving us great detail, then simply said you can't
get it to work.