How to hide Query in mdb file

[mrchonginhk]

I have built queries, reports and forms in mdb file and sent to user to use.
It has autoexec marco to load forms and I have made it mde file so users cannot change codes and I have made the form to be full screen.

However, there is still a small 'restore windows' icon on upper corner in not the form but on the tool bar File, Edit, View, Insert that bar on far right side and so users are still able to shrink this form and reveal the Access's query and table views. I already clicked "No" to close buttons and control box already.

Is there any way to make it impossible or very difficult for user to see/change queries.
Any way to compile Access etc ?

Thanks

 

[SydneyGeek]

In Tools | Start up (I think), there is a checkbox called Show Database Window. Deselect it. You will need to set a startup form to display when the database launches.
Next time the DB opens you will see the form. If you close the form the database container will not be visible. You can bypass this by holding down the SHIFT key as you launch the DB, so that you can work on the design.

Denis

 

[mrchonginhk]

This is greaaatt... Thanks !!

 

[SydneyGeek]

You're welcome

Denis

 

[mdmilner]

If you're only focused on the queries, what about not using them at all? You could just setup a custom form to present the information that uses a SQL statement (the same SQL statement that the query would use).

 

[Hermanito]

hmmm, I didn't know Marco came in an autoexec version as well...