Cher has attended:
Access Introduction course
Access Advanced course
Access Intermediate course
Macro for hiding database
I would like to know how how to write a macro to hide tables from other users to disallow potential edits on key data.
Many thanks.
RE: 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
RE: Macro for hiding database
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.
