switchboard and tables

L

Lin Light

I have a switchboard application setup. I have the buttons and such pointing
to the right reports, forms, etc. but i would like to hide the actual
database tables, querie, forms and reports and such from the users. I want
them tojust use the switchboard and not have access to the database driving
the switchboard. I don't have Vis. Basic experience and knowledge.
Lin
 
V

Van T. Dinh

Use the Menu Tools / Startup ... and uncheck the "Display Database Window"
option.

Note that this is _not_ a security measure. Anyone with a bit of Access
knowledge will be able to display the Database Window.
 
L

Lin Light

I still have the database minimized. I can just click on Restore and there it
is.
 
V

Van T. Dinh

Are you using the Switchboard created by the Switchboard Manager?

If this is the case, the code in the Switchboard makes it visible again
after you hide it with the Start-up Options.

There is a "DoCmd.SelectObject" in the code behind the Switchboard that
makes the Database Containers window visible. Apparently, you can comment
out this line of code and the Switchboard still works fine. However, I
can't give you the exact instruction as the last time I looked at the
(Access) Switchboard was a long time ago in Access97.
 
Top