Can a user run query but don't be able to go into query design

Guest · Oct 21, 2005

I want my users to be able to run queries, but not able to go into the design
mode and change the query. How do I do it?

Denis Dougall · Oct 21, 2005

Custom the toolbar and exclude design view.

Denis

Lynn Trapp · Oct 21, 2005

You would need to implement User Level Security and create RWOP queries.
Information on that is contained in the Security FAQ. There is link to it on
the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Parameter Query Won't Run	0	Jun 3, 2015
Queries, see new fields when table design has changed	2	May 19, 2009
It takes SO LONG TIME to open a query in design mode	3	Jan 7, 2010
Schedule Auto run Query on append table	0	May 14, 2012
Pull a field from a form to be the criteria of an append query	0	May 20, 2011
result query on a form	1	Jan 20, 2011
Strange Query Behavior	13	Jul 30, 2009
Combine Duplicates in Query	0	May 5, 2016

Ask a Question