access+training+in+london - Macro for hiding database

Hi Cher

Sorry for the delay in getting back to you but our offices have been closed over the Christmas period. We our now processing all of our forum entries and we will be back to you very shortly with an answer to your question.

David

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.
When the Properties window appears, select the checkbox called "Hidden". Then click on the OK button.

and to view these hidden tables in the database window?

goto the Tools menu, select "Options".
When the Options window appears, select the view tab and check the "Hidden objects" checkbox. Then click on the OK button.

This will return you back to the database window where you should now be able to see all hidden objects including the hidden tables that you are looking for.