hide design view in query

[sawilliams]

I have a reports form that has control buttons to run queries. The user uses these queries to do merges or to copy the data to Excel for further manipulation. I don't want the user to be able to open the query in design view. But they need to be able to write their own queries. How do I lock the query design view for the queries that are run from my reports form?

 

[GingerR]

Do you have your db split into a front-end/back-end set up? If not, you should! I never let my users do any design work in my front-end. If someone wants to design stuff, they can have a separate front-end to do that in.

That being said: you can right-click on an object and set it's HIDDEN property. Then, if a user never figures out how to view HIDDEN objects, you're home free. It's a hokey work-around, but maybe that's all you need.

Ginger

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[dhookom]

Hi Ginger It's good to see you back here.

sawilliams,
Ginger's advice on splitting is gospel in developing Access applications. If you want to allow users to create queries, consider downloading and implementing the Query By Form applet at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Another qbf example:

http://download.microsoft.com/download/access2000/Sample/1.0/WIN98Me/EN-US/Qbf2k.exe

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sawilliams]

Thanks all... I have not had time to look at the links you left me but I have already split the db AND made the query hidden (in fact it is named with the prefix "usys" to hide it as a system object. Still when I open the form from which the query (or report) runs and run the query, I can still click on the design button and modify the query. If a user tinkers with in the design view, it will be nasty.

 

[dhookom]

Create an MDE from your front-end file so users will not be able to go to a form or report design view.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]