There are two methods to hide a table from view in the Database window.
- Right click on the table in the Database window and check the "Hidden"
checkbox.
-
From code, run code equivalent to this
With CurrentDB.TableDefs("ToHideOrNotToHide")
.Attributes = .Attributes or dbHiddenObject
End With
Even though these two methods may seem equivalent on first glance, don't
use dbHiddenObject from code!!
Michael Kaplan had warned
previously that the use of this flag is ill advised.
To re-iterate the warning, if you add dbHiddenObject to any table's
Attributes, the table will be deleted during a compact operation.
|
