Hidden the Table

  • Thread starter Thread starter Ginola
  • Start date Start date
G

Ginola

Hi,

I have a Access file which have queries, tables and forms. I just
wonder how can I limit the user so that they can open the form only
without seeing the table or query ??

Thanks
 
Ginola,

The right way to do this is apply Access security to restrict users' rights.

Alternatively, you can hide objects in the database window by setting their
Hidden property (right-click on the object), but this wil only work on
"idiot" users; all it takes to by-pass it is to go to Tools > Options and
set the View Hidden Objects check box.
HTH,
Nikos
 
Thanks, I actually also want to limit the user to open other access
file. My question is how can I hide some ( or all ) the menu bar ?
 
Ginola,

Yes, you can. You can (a) use the options under Tools > Startup to only
allow a restricted subset of the "normal" menu, or (b) run some code at
startup to hide the menu bar altogether. The code statement would be:

Application.CommandBars("Menu Bar").Enabled = False
Things to note:

Both options can be by-passed by simply holding the Shift key pressed while
the database is being opened, unless you disable the shift by-pass key
through more code.
If you go for option (b), you must make sure that some event (closing of a
main form?) before the database is closed will run a line of code to reverse
the setting, so the menu bar is available to the user when they open another
database.

HTH,
Nikos
 
Back
Top