Hide Tables (2000)

Topic

New Reply

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

Reply | Quote

Replies

Tools / Options… / View tab – check the Hidden Objects box in the “Show Section”

Reply | Quote

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

Reply | Quote

Maybe a visual will help more. The menus are slightly different because I am using Access 2003.

Reply | Quote

THANK YOU!

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

THANK YOU, it’s back. It kind of looks ghostly; the icon color looks faded. Is that okay?

Reply | Quote

You still have to right click the table, select Properties and clear the Hidden attribute.

Reply | Quote

Ah ha! Perfect. Thanks.

Reply | Quote