Experts Exchange connects you with the people and services you need so you can get back to work.
Improve company productivity with a Business Account.Sign Up
Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.
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
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.