to make query design menus visible when in a query

[R32chaos]

Hello members...

I have a unique dilemma; the database is made to open without any menus/toolbars visible and i have developed shortcut menus for reports and forms.
I had to make some queries accessible via buttons to users to be able to modify the design and view data for printing purposes etc.

Problem is, when the database is opened in a locked/secure state users do not have design access, they may open the queries but cannot view their results etc. Is there anyway to make the query design (default) menu/toolbar visible when they are in query design only?

thanks in advance!

Regards, Martin

 

[Pat Hartman]

No. You will need to change your design. Users should NEVER be given access to design tools in a multi-user application. If your users need to create their own custom queries and reports, create a separate database that links to the tables and build them some basic queries to start with.

 

[R32chaos]

Thank you Pat!

Appreciate the tip, thats the solution and makes complete sense.

Regards, Martin