Permissions problem

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

Guest

I found the level of security in my database that I wanted, from the Access
help menu. I want users to run queries but not change the data or query
design. I set the "RunPermissions" property on each query to "Owner's",
instead of the default "User's". Now one can only view data after the query
returns the results. This works fine for all except one of the queries. It's
a select query like the others, but one can still go in and change data after
the query runs. I can't figure out what's wrong. Any ideas?
 
For the query, I unchecked all except "Read Data" permissions for the query.
All the other queries that are working ok had everything checked. Even after
I did this, I can still change the data.
 
The query is a paramter query, and it's based on one table which has only
"read data" checked.
 
What you are describing doesn't add up.

The underlying table is not owned by the user.
The user has only read data permission on the table (Since the query is
RWOP, the user doesn't need *any* permission on the table, BTW)
The query is not owned by the user.
The query has only read data permission on it.

The user, therefore should not be able to do anything except read the
data/design.
 
I know, I can't figure out what's wrong. The strange thing is that all the
other queries permissions work fine, and most are based on the same table. I
didn't do anything complicated, and just this one won't work right.
 
Back
Top