none
Show hidden table in Access 2007 or 2010

    Question

  • Greetings to all of you Folks and a happy new year,
     
    I recently came to a dead end when I tried to show a hidden table in Access
    2007 and Access 2010.
    I downloaded a database examble (how to print a treeview control in an
    access report) and when I
    was looking at the Rowsource of the report I discovered that there was a
    table name that was not apparent
    in the tables tab. I tried to find the Command which was similar to the 2003
    version ( In Access 2003 you
    could go to Tools >> Options >> View and then you had to check the checkbox
    to show hidden objects)
    but I couldn't locate it at all. I suppose since the table does not show in
    tables tab Microsoft did not
    discontinue the show/hide table option. All the help you can give me will be
    highly appreciated and if
    you think you 've got the answer do not feel embarashed to share it with
    me... :)
     
    Cheers from IMF victims in Greece,
    Nikolaos
     
     
    Thursday, January 06, 2011 1:31 PM

Answers

  • In Access 2007, click on the Office logo (the big circle in the upper left-hand corner), go into Access Options, select Access Options (at the bottom) and look at the properties for the Current Database. About half-way down, you should see Navigation. Click on the Navigation Options... button. There are display options in the bottom left-hand of the form that pops up.

    In Access 2010, click on the File tab and look for Options. It's the same as in Access 2007 from then on...


    Doug Steele, Microsoft Access MVP
    http://www.AccessMVP.com/djsteele (no e-mails, please!)
    • Proposed as answer by Bruce Song Wednesday, January 12, 2011 7:57 AM
    • Marked as answer by Bruce Song Wednesday, January 12, 2011 12:45 PM
    Thursday, January 06, 2011 2:37 PM
  • In the Navigation pane (pain)

    Right click on the All Access Objects and select Navigation options...

    That will open a dialog for you to show hidden objects.

     


    John Spencer Access MVP 2002-2005, 2007-2011 The Hilltop Institute University of Maryland Baltimore County
    • Proposed as answer by Bruce Song Wednesday, January 12, 2011 7:58 AM
    • Marked as answer by Bruce Song Wednesday, January 12, 2011 12:45 PM
    Thursday, January 06, 2011 2:44 PM

All replies

  • In Access 2007, click on the Office logo (the big circle in the upper left-hand corner), go into Access Options, select Access Options (at the bottom) and look at the properties for the Current Database. About half-way down, you should see Navigation. Click on the Navigation Options... button. There are display options in the bottom left-hand of the form that pops up.

    In Access 2010, click on the File tab and look for Options. It's the same as in Access 2007 from then on...


    Doug Steele, Microsoft Access MVP
    http://www.AccessMVP.com/djsteele (no e-mails, please!)
    • Proposed as answer by Bruce Song Wednesday, January 12, 2011 7:57 AM
    • Marked as answer by Bruce Song Wednesday, January 12, 2011 12:45 PM
    Thursday, January 06, 2011 2:37 PM
  • In the Navigation pane (pain)

    Right click on the All Access Objects and select Navigation options...

    That will open a dialog for you to show hidden objects.

     


    John Spencer Access MVP 2002-2005, 2007-2011 The Hilltop Institute University of Maryland Baltimore County
    • Proposed as answer by Bruce Song Wednesday, January 12, 2011 7:58 AM
    • Marked as answer by Bruce Song Wednesday, January 12, 2011 12:45 PM
    Thursday, January 06, 2011 2:44 PM