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

Posted on 2011-10-13
Last Modified: 2012-05-12
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)?

Question by:pcalabria
    LVL 84

    Accepted Solution

    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.
    LVL 56

    Assisted Solution

    by:Jim Dettman (Microsoft MVP/ EE MVE)

      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.


    LVL 26

    Assisted Solution

    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


    Author Closing Comment

    Thank you,

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

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now