securing a table

  • Thread starter Thread starter Brian Starr
  • Start date Start date
B

Brian Starr

I have a db set up with user level security. Is there any way to prevent a
user from viewing the data in a table that they can add/edit records in?
Here's what I am planning:

I need to set up a db for employee evaluations. One table will house all
evaluations. Each evaluation represents a record. I want the individual
evaluators to be able to add or see their own evals exclusively. To
accomodate this, I have set up a field in the table that will store the
result of the CurrentUser function.

In addition, I was planning on setting up a query that would be used to add
or edit evals, and would filter the data seen by using the CurrentUser
function. If I am not mistaken, the only problem this presents is that the
user could open the table and view all of the records. Does anyone have
suggestions? A simple solution would be nice. Thanks a million!
 
You would set the query's 'run permissions' property to Owner's. Open the
query in design view, View Properties, and click in an empty area of the
upper pane.

You then can deny permissions to the tables completely for your users. When
they run the query, they will run it with the query owner's permission.
 
THANKS!!


Joan Wild said:
You would set the query's 'run permissions' property to Owner's. Open the
query in design view, View Properties, and click in an empty area of the
upper pane.

You then can deny permissions to the tables completely for your users. When
they run the query, they will run it with the query owner's permission.

--
Joan Wild
Microsoft Access MVP

prevent
Click to expand...
 
Back
Top