How to hide database window in Access 2007

[Pete]

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

 

[Clifford Bass]

Hi Pete,

Office button (upper left), Access Options button, Current Database
section, Navigation subsection, Display Navigation Pane.

Clifford Bass

 

[Pete]

Brilliant. Thanks.

Hi Pete,

Office button (upper left), Access Options button, Current Database
section, Navigation subsection, Display Navigation Pane.

Clifford Bass

 

[Clifford Bass]

Well, not brilliant. You are welcome Pete!

Clifford Bass

 

[AlexML]

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

 

[Clifford Bass]

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]

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]

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]

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.

 

[Clifford Bass]

Hi Alex,

You are welcome. Good luck!

Clifford Bass