Hidden data

[Guest]

I have a database and I hid the tables, queries, reports so that when
somebody opens the database, just the main page appears. If I want to se the
tables, queries, etc. I need to go to to the menu, select Window, Unhide and
select the data I want to see. I would like to set up my database so that
nobody can see the tables, queries, reports and forms even clicking on
window, unhide. How can I do that? Is that possible?

 

[Chris Mills]

Normally you would set your program to startup in some "Menu" form. They would
need to know which key to hit to get to the "Database Window", and if they
know that then quite likely they know a lot more.

There is a way to "disable startup keys", but if you have to ask, and since
there's a likelihood of locking your goodself out, I'm not sure it's the best
solution.

You can just put "/Runtime" on the shortcut to start your app. Hardly a
security measure if they know how to set shortcuts, but it could do what you
want.

Associated with "Runtime", (and otherwise), you can make your own "custom
menus", where you allow only the menu options you want them to have. Look at
View, Toolbars, Customize. You can remove the option to Hide/Unhide "Windows".

Bear in mind, this would not be thought of as a "significant security
measure", but it will prevent users from doing "inadvertent" things.

Chris

 

[Joan Wild]

Use the features in Tools, Startup to
disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
hide the db window
uncheck the allow special keys (this will disable the F11 key, among
others)

Doing just that will present a limited menu to your users. You could also
create your own custom menu and use it. Just ensure that the Window, Unhide
option isn't available. Then set your menu as the default in Tools,
Startup.

If you need to bypass the startup features, you can hold the shift key down
while you open the db. If you feel that your users may use this to bypass
your settings, you can disable the shift key bypass - there's an example in
help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm