Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
One thing with the Hidden attribute, make sure you don't set the dbHiddenObject attribute on a table. This is a JET level attribute and you will loose the table on the next compact and repair if it's set.
Yeah ... that bug has been around a long time.
Public Sub HideTable(strTablename As String)
.Attributes = .Attributes Or dbHiddenObject
Public Sub UnHideTable(strTablename As String)
If dbHiddenObject = (.Attributes And dbHiddenObject) Then
.Attributes = .Attributes - dbHiddenObject
Open in new window