Is it possible to control navigation pane display options on a per-database basis?

Question

Hi,

I am developing an Access application and would like to make the Navigation Pane a part of the application. I have created a custom category, added relevant groups and objects to it, and have set this category to be the only category displayed in the navigation pane to the user. 

However, even if I configure the display options for the current DB to hide all hidden objects and system objects in the Navigation Pane, and even if I lock down the possibility for the user to make changes to the Navigation Pane in the DB, it is possible for the user to change the display options by opening another Access DB and making changes to the settings there. Apparently the Navigation Pane display option settings are global, and not specific to the current DB (although the location of the settings, under "Current Database", suggests the opposite).

So my question is, how can I lock down the Navigation Pane really? Or is there an alternative to the Navigation Pane which provides similar functionality and usability in an Access application? 

Many thanks for any suggestions!

---

matek994

Answer 1

So my question is, how can I lock down the Navigation Pane really? Or is there an alternative to the Navigation Pane which provides similar functionality and usability in an Access application? 

Hi Matse,

I never use the Navigation Pane.

Instead I use a regular form tuned to the functionality of the Navigation Pane. Each application then has its own "navigation pane".

Imb.

Answer 2

Users should never have access to the Nav Pain.  Create your own interface (listboxes, treeview, ...) to control what they have access to.

---

Daniel Pineault, 2010-2018 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 3

You're asking too much of the Navigation Pane. It was never designed with that in mind.

Alternatively use the Ribbon, or a Switchboard form <shudder>.

---

-Tom. Microsoft Access MVP