Only Allowing Select Queries

[CJS]

Is there a way I can only allow users to create select queries?

 

[Joan Wild]

The easiest would be to allow them to create any query they like, but set their permissions on the underlying tables to only Read Data; that will prevent them from actually updating/deleting/inserting records.

 

[CJS]

The users do need to update tables from forms. I just don't want them to
write queries to update,insert,delete.

 

[Joan Wild]

In that case, I'd create RWOP (run with owner permissions) queries for all your current data interaction (forms/reports). You'd give the users the update permissions on these queries, and leave the permissions on the tables set to Read Data. Read more about RWOP at www.jmwild.com/RWOP.htm

--
Joan Wild
Microsoft Access MVP

The users do need to update tables from forms. I just don't want them to
write queries to update,insert,delete.