Access 2007 Side Bar Lock

[hfd]

Is there any way for me to lock out the sidebar of a mdb file I am
working on. I am planning on passing it out to users and don't want
them changing any of my work. Any and all comments are appriciated.
Thanks!

Dan

 

[Jeanette Cunningham]

You can set the properties of the application to hide the sidebar -
otherwise known as the Navigation Pane.
Click the Office button at top left, choose Access Options bottom, choose
Current database from list on left near the top, choose Navigation pane and
set it to hide the nav pane.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tom Wickerath]

Hi Dan,

By "sidebar", do you mean the new Navigation Pane (aka Navigation Pain)? Try
using the method that Access MVP Oliver Stohr discusses on his tutorial page
(scroll about 45% down the page--just above the halfway mark):

http://www.access-freak.com/tutorials.html


<Begin Quote>
Hide/Unhide Navigation Pane with code:

This topic might be closely related to the sample we have just covered.
Sometimes you might want to give users with appropriate rights in a secured
environment the possibility to work with the Navigation Pane.

The startup options under the Current Page allow you to hide the Navigation
Pane similarly as you might have been doing with the Database Window in
earlier Access versions.

To programmatically show or hide the Database Window or Navigation Pane you
can run the sample code shown in the code example 3.2:

'----- show the Database Window or Navigation Pane
DoCmd.SelectObject acTable, “YourTableâ€, True

'----- hide the Database Window or Navigation Pane
DoCmd.SelectObject acTable, “YourTableâ€, True
DoCmd.RunCommand acCmdWindowHide

Code Example 3.2: Showing or hiding Database Window

When utilizing the above code to show or hide the Database Window it is not
necessary to actually specify a true existing database object name in the
ObjectName argument of the SelectObject method of the DoCmd object. However,
when trying to show or hide the Navigation Pane in Access 2007 it is required
to pass along an existing object name for the code to function correctly.

Though you might not even want to completely hide the Navigation Pane or
reveal it to certain users in Access 2007 anymore. The Navigation Pane can
be an integrated part of your application and serve as a very interactive
switchboard replacement.

Access 2007 introduces three specific macro actions which will help
developers with the customization of the Navigation Pane. We will look at
this topic later on when discussing the implementation of these new Access
features. For now let us mention the three macro actions without going into
too much reasoning and detail about their functionalities. The
SetDisplayCategories action allows the developer to show or hide specific
categories to the user. The NavigateTo macro action enables us to organize
categories and database objects within the Navigation Pane and the
LockNavigationPane action prevents anyone from mistakenly cutting or deleting
database objects from within the pane.

</End Quote>


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________