Update table only through query

[Rick Cochran]

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

 

[Joan Wild]

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.

 

[Rick Cochran]

Thanks Joan!

That's just what I needed.

R

-----Original Message-----


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.


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.


--
Joan Wild
Microsoft Access MVP


.