Navigation Pane pain in 2007

[M Skabialka]

I don't want users to see the Navigation Pane so I changed the option to NOT
Display Navigation Pane but it is still there compressed over to the left
side, easy to open by curious users. I have read that this is because I
have linked tables, and even tested this by opening to a startup form with
no control source. The Navigation Pane didn't show up until I then opened
the data form where users do their data entry. I have played around with
the Navigation Options but even when I uncheck everything, tables and
related views, object type and custom, which makes it look as though the
Navigation Pane is empty, I can still go to the Navigation Pane, right click
and choose something like Sort by Created Date and all of the objects become
visible to users who want to see how everything works, and could potentially
scramble something in the tables.
I would rather it be totally invisible - is there another setting I can
change?
Mich

 

[Beetle]

Click the Office button in the upper left corner, go to Access Options /
Current Database. Near the bottom you will see a checkbox for
Display Navigation Pane.

 

[M Skabialka]

As I said - "I changed the option to NOT Display Navigation Pane" which is
your suggestion. It doesn't work if there are linked tables. I need
another solution.

 

[Gary L. Steward]

Mich, I have the same desire for the database I have. Have you found a
solution to not displaying the navigation pane?

 

[giuseppe]

In Access Options, Current Database, I removed the check on Use Access
Special Keys (to stop them using F11 to get to the tables, etc), removed
the check from Display Navigation pane, and added the last line below to
my code in the On Open event of the form:

' Minimize the database window.
DoCmd.SelectObject acForm, "frmMain", True
DoCmd.Minimize
RunCommand acCmdWindowHide

If I need to get to the Nav pane I right click any form, report, etc
header, and select Design view. That brings it back until the next time
the database is opened. Figuring this out was a frustrating experience!

Mich