[AccessD] Hidden Tables

Once you have selected Tools-Options-View-Hidden Objects, you can right click on the 
table, select Properties and  "unhide" it  

Also, you can also create a System Table by naming it
usysxxxxxxxx or msysxxxxxxx

If the table starts with either of these four character strings, it is only visible if you check the 
box  Tools-Options-View-System Objects.  

It's not a good idea to use msysxxxxxxx because Access uses that for real system tables, 
but usysxxxxx is handy for hiding your own tables.  

I use it quite often for tables holding system information, user login data etc


On 12 Feb 2009 at 6:49, jwcolby wrote:

> There is a property in Tools / options / views, the hidden check box.  If that is checked then the 
> hidden objects will (I believe) be shown as grayish but still visible.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Arthur Fuller wrote:
> > I know that you can hide a table by right clicking and then choosing
> > Properties and filling the Hidden checkbox. But once it's hidden, how do you
> > unHide it?
> > 
> > TIA,
> > Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com