Hidden the Table

[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

 

[Nikos Yannacopoulos]

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

 

[Ginola]

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 ?

 

[Nikos Yannacopoulos]

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