Hidden Tables

[Guest]

To prevent users accessing the data in the Tables, I have hidden each
sensitive Table.
I thought this was very clever, but now I need to access the tables. I do
not however know how to UNHIDE the Tables.

Would appreciate advice on where to find the UNHIDE command.

 

[Douglas J. Steele]

The simplest approach is to go into Tools | Options and set Access to show
hidden objects. You'll then be able to work with the hidden objects,
unhiding them if you like.

 

[Rick Brandt]

To prevent users accessing the data in the Tables, I have hidden each
sensitive Table.
I thought this was very clever, but now I need to access the tables. I do
not however know how to UNHIDE the Tables.

Would appreciate advice on where to find the UNHIDE command.

The solution will show you that it is not really that clever for protecting
tables.

Tools
Options
View
Show - Hidden Objects

Some of your users could be aware of this very setting or stumble upon it later.

 

[Guest]

For those of you using Access 2007, the below guidance is less than
sufficient. The "Show Hidden Objects" command is available in Access 2007
under the Navigation Options button in the Access Options window. This is
found via the menu path |Office Button |Access Options |Current Database
|Navigation |Navigation Options.

I'm resurrecting this post to share the Access 2007 path, since before
stumbling upon the answer myself, I found no such guidance in help or web
searches.

//Karl