How to Restrict Users to view/go to Query Design/Sql mode in MDE/M

[Girish]

I want to secure my Access MDE file so that My users can not go to Design /
SQL view of the query. Currently after opening query through command button
provided by me on form , any user can press right click button & Go to
design/Sql view of the query & fiddle with it. I want to keep enable right
click mouse button but disable "Query Design" option. Like for forms &
reports design option is not available after creation of MDE file. I am not
in a position to use Security & group wizard provided by Access. Please
Guide. Thanks . Girish

 

[Dale Fye]

Disabled the default shortcut menus. Select Tools ->Startup from the main
menu. Then uncheck the Allow Default Shortcut Menus.

HTH
Dale

 

[Girish]

Thanks. But This disabled complete context menu. I want to allow my users to
use Filter options that are available in Right Click Menu.

I want to disable only "Query design" choice from right click menu.

Thanks Once Again Dale.

Girish

 

[Dale Fye]

Create your own pop-up window with just the functionality you want. It is
really pretty easy. If you don't know how, and would like to learn, post
back and I'll provide some basic instructions.

Dale

 

[Girish]

Dear Dale,

I can generate Po up window to filter out records in form. Thats a v good
suggestion for less complex project.

Problem is I have nearly 78 Queries for which I dont want to create any form
& on switchboard I am allowing users to access queries directly by
docmd.openquery command. Due to large no of queries I am trying to avoid
creating so many forms as my project may become quite bulky & big.

If i have not understood your suggestion properly please guide me with some
basic instructions. If possible please give me code to disable Query design
option.

Girish