Query design view disable

[aajaydee]

I have build small program and allowed user to build query for search
is there any way I can restrict them to modify data
like disable menu bar when user see query in desing view


Thanks

 

[wtmckown]

In query properties change recordset type to snapshot which is not updatable.

 

[aajaydee]

I want some how either disable menu bar or some thing that prohibits user to make any modification in query in design time

 

[PHV]

allowed user to build query for search
Why not using Query By Form (QBF) concept instead of allowing the user to go in query design view ?
An example here:

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