10/07/2012

Hide tables as hidden objects

Question: In an Access 2003/XP/2000/97 database, I've created a table that I don't want others to see. How can I hide a table from appearing in the database window?
Answer: If you don't want users to see a table in an Access database, you can mark the table as a hidden object.

To do this, right-click on the table that you wish to hide and select Properties from the popup menu.
copyright www.TechOnTheNet.com
When the Properties window appears, select the checkbox called "Hidden". Then click on the OK button.
In this example, we've hidden the table called Suppliers. This table still exists in the database but you can no longer see it in the database window.
To learn how to display hidden tables in the database window, click here.

No comments:

Post a Comment