Hiding Database Window

[Don]

Hello, I have an access 97 application that I build into an mde. The
database window is still available by going to the window menu item and then
the unhide menu item. I don't want the users to be able to see the table
section in the database window item. I've changed the database
property(AllowFullMenus) to false, this then hides the items(hide/unhide)
from the window menu item. Unfortuntely, after doing this some toolbars I
display on reports to allow users to change the printer locations are then
also disabled. How do I only disable the hide/unhide menus under the window
menu item.

Thanks

Don

 

[tina]

suggest you "turn off" the Access menus and toolbars at database startup.
create custom menus for your forms and reports, to provide only the specific
options that you want your users to have access to.

btw, it's easy for any user to bypass the the start up options when the
database is opened, thus allowing access to the database window (and the
tables) again - and information on how to bypass startup is scattered all
over the internet, as well as in many Access manuals. at the very least, you
should "turn off" the bypass option in your database - at the very most, you
should consider implementing Access user-level security (carefully, after
much reading on the topic, and much practice).

hth

 

[MikeC]

Don,

You can insert the below code in the Activate event procedure for your
switchboard form or whatever form you are opening during startup. This way,
you may be able to avoid having to disallow full menus.

With CommandBars("Menu Bar").Controls("Window")
.Controls("Hide").Enabled = False
.Controls("Unhide...").Enabled = False
End With

I also agree with Tina's previous comments regarding disabling the shift key
override. If users can override your startup options, then the above will
be bypassed by any users who know how to use the shift key override.