"Pete" wrote:

> In Access 2007 the Tables etc are visible to the left of the Switchboard. How
> is this kept hidden from Users? Thanks

"Clifford Bass" wrote:

> Hi Pete,
>
>      Office button (upper left), Access Options button, Current Database
> section, Navigation subsection, Display Navigation Pane.
>
>                       Clifford Bass
>
> "Pete" wrote:
>
> > In Access 2007 the Tables etc are visible to the left of the Switchboard. How
> > is this kept hidden from Users? Thanks

"Pete" wrote:

> Brilliant. Thanks.

"Clifford Bass" wrote:

> Well, not brilliant.  You are welcome Pete!
>
>          Clifford Bass
>
> "Pete" wrote:
>
> > Brilliant. Thanks.

"AlexML" wrote:

> But then how can I prevent users from re-enabling the Navigation Pane? 
> It was quite easy with Access02...

"Clifford Bass" wrote:

> Hi Alex,
>
>      Well, you could turn off the usage of special keys in the Application
> Options of the Current Database section.  But that does not stop someone from
> just going back into there and turning them back on.  Or from using the
> hold-shift-down-while-opening trick.  So you maybe be left with creating an
> MDE or ACCDE version of your file.
>
>      Perhaps others know different?
>
>                  Clifford Bass
>
> "AlexML" wrote:
>
> > But then how can I prevent users from re-enabling the Navigation Pane? 
> > It was quite easy with Access02...

"AlexML" wrote:

>
> Removing the Office button (top left) would prob do the trick, since there
> is no other way of getting to Access Options.. what do you think? any ideas>?
>
> "Clifford Bass" wrote:
>
> > Hi Alex,
> >
> >      Well, you could turn off the usage of special keys in the Application
> > Options of the Current Database section.  But that does not stop someone from
> > just going back into there and turning them back on.  Or from using the
> > hold-shift-down-while-opening trick.  So you maybe be left with creating an
> > MDE or ACCDE version of your file.
> >
> >      Perhaps others know different?
> >
> >                  Clifford Bass
> >
> > "AlexML" wrote:
> >
> > > But then how can I prevent users from re-enabling the Navigation Pane? 
> > > It was quite easy with Access02...

"Clifford Bass" wrote:

> Hi Alex,
>
>      You may want to look at custom ribbons.  See
> <http://www.utteraccess.com/forums/showflat.php?&Number=1423199> for a
> tutorial.  But I do not think this disables the shift-while-opening option.
>
>                Clifford Bass
>
> "AlexML" wrote:
>
> >
> > Removing the Office button (top left) would prob do the trick, since there
> > is no other way of getting to Access Options.. what do you think? any ideas>?
> >
> > "Clifford Bass" wrote:
> >
> > > Hi Alex,
> > >
> > >      Well, you could turn off the usage of special keys in the Application
> > > Options of the Current Database section.  But that does not stop someone from
> > > just going back into there and turning them back on.  Or from using the
> > > hold-shift-down-while-opening trick.  So you maybe be left with creating an
> > > MDE or ACCDE version of your file.
> > >
> > >      Perhaps others know different?
> > >
> > >                  Clifford Bass
> > >
> > > "AlexML" wrote:
> > >
> > > > But then how can I prevent users from re-enabling the Navigation Pane? 
> > > > It was quite easy with Access02...

"AlexML" wrote:

>
> Clifford,
> Thanks much for your help... I think for the purpose of what i'm trying to
> do,
> simple
>  DoCmd.ShowToolbar "Ribbon", acToolbarNo
>
> does the trick ---> seems to gets rid of all the ribbons and Microsoft
> Access button.