We are working with a very small group. If I hide a table, how do I make it appear again?
We are working with a very small group. If I hide a table, how do I make it appear again?

This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
Tools / Options... / View tab - check the Hidden Objects box in the "Show Section"
On the Tools menu, click Options.
Click the View tab.
Under Show, select the Hidden objects check box. Microsoft Access displays hidden objects with dimmed icons to distinguish them from objects that aren't defined as hidden.
Under Objects in the Database window, click the type of database object whose properties you want to change.
Click Properties on the toolbar.
Clear the Hidden check box.
Francois
http://www.wopr.com/S/Belgium.gif
I was "playing around" and right clicked on a table but now I don't know how to make it appear again.
Right Click - Properties - Hidden
Thank you for the reply. You've probably explained it but I'm still a bit confused. Sorry.
I right clicked on a table, went into the properties, and selected hidden. I just don't know how to make it appear again. It's now hidden so I can't click on it.
With the database window open, select Tools in the Menu bar, then option, then the Tab View and in the section Show, select the Hidden Objects
Francois
http://www.wopr.com/S/Belgium.gif
Maybe a visual will help more. The menus are slightly different because I am using Access 2003.
THANK YOU, it's back. It kind of looks ghostly; the icon color looks faded. Is that okay?
THANK YOU!
You still have to right click the table, select Properties and clear the Hidden attribute.
Francois
http://www.wopr.com/S/Belgium.gif
Ah ha! Perfect. Thanks.