Update table only through query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick Cochran - 23 Sep 2004 15:20 GMT

I would like to limit a user to updating a table only
through a query. I have attempted this by giving the user
permissions to Insert, Update and Delete Data in the query
while allowing her read-only access to the underlying
table. This setup only allowed the user to view data in
the query.

Is there a way to limit this user to changing data only
through the query without resorting to creating a
switchboard specifically for her?

Details: There are two groups at present: Admin, which has
full access and Users, who have read-only access to the
entire database. I've set up a third group for this user
who should ideally be able to view/change only the query
while only viewing the underlying table.

TIA - Rick

Reply to this Message

Joan Wild - 23 Sep 2004 23:13 GMT

> I would like to limit a user to updating a table only
> through a query. I have attempted this by giving the user
> permissions to Insert, Update and Delete Data in the query
> while allowing her read-only access to the underlying
> table. This setup only allowed the user to view data in
> the query.

Open the query in design view, and open the properties window. Change the
Run Permissions property to Owner's. Then you don't need to give the
user(s) any permissions at all on the underlying tables.

When they run the query, they'll be able to access the table data because
they are 'running with owner permissions', meaning they have the query
owner's permission to access the table. As long as the query owner has
permission on the tables, they'll be given access. They are, however,
restricted to what they can do by the permissions set on the query.

> Is there a way to limit this user to changing data only
> through the query without resorting to creating a
> switchboard specifically for her?

Usually you'd create a form for the users to view/modify data, rather than a
query. You have more control (validation, error handling), than you do with
queries.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Rick Cochran - 24 Sep 2004 14:33 GMT

Thanks Joan!

That's just what I needed.

R

>-----Original Message-----
>> I would like to limit a user to updating a table only
[quoted text clipped - 21 lines]
>query. You have more control (validation, error handling), than you do with
>queries.

Reply to this Message