How do you hide the database window (Nav Pain) in Access 2010

I've been programming in Access 2K for years and am now learning Access 2010.

In Access 2K I could hide the database window so that clients did not have access to the tables, querries, macros, etc. unless they had knowledge of the Access Special Keys.

Access 2010 seems to have done away with the Database Window in favor of a Navigation Pane, which also means the Hide Database Window option, previously in Tools -- Startup... is now missing.

I would like to roll out compiled copies of my Front End to my clients prevent them from even seeing the database window and ribbon, so that the only thing they see are the switchboard menus that I created.

Can I do this?  If so, will there be an easy way for me to remove these restrictions when I startup Access 2010 (Such as holding down the control key)?

Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
There's an option to hide the Nav Pane:

File - Options - Current Database, uncheck "Display Navigation Pane"

Same caveats apply with this version regarding the Shift Key (i.e. holding down the ShiftKey will always display the Nav Pane), so be aware of that.
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:

  Do a DoCmd.RunCommand acCmdWindowHide at startup or in the autoexec macro (probably a better place as you must issue the command before anything becomes visible).

  You can also do a SendKey's with Ctrl/F11 to hide/un-hide as needed.


Nick67Connect With a Mentor Commented:
Something good to experiment with is re-naming (providing you are doing an accde) your accde file to accdr.
This makes Access function as if it were the run-time version
There is a very extensive discussion of how to lock down an Access 2010 app here

By the time we ground through that, the methods for securing the objects and locking down the Ribbon, Nav Pain, BackStage and Quick Access Toolbar were all laid out

The Access options in the File tab (BackStage) has the option to disable the Nav Pain, as @LSMConsulting noted
Display Nav Pain<<
The links within the thread do supply all the detail to exercise granular control over the Ribbon.  The Quick Access Toolbar cannot be hidden but it can be disabled.  Deploying as an ACCDR renders most of the Ribbon inaccessible.  That can be done in an MDB and ACCDB (MDE or ACCDE) as well BUT removing the MRU would have to be done through a registry hack.  Everything else can be completely customized.

How to load custom Ribbons via code
Customizing the QAT
Right-click context menu customization 
Customize the BackStage itself if you are brave or crazy enough 

By far, Gunter's site at is where you need to start

pcalabriaAuthor Commented:
Thank you,

I split the points as I used info from all!
Thank you very much
All Courses

From novice to tech pro — start learning today.