-
hidden table names
There is a way to hide the tables from the users even when looking at a table view. I have a customer who I hid the table names from many years ago, but can't remember how it is done. I need to get back into some of those tables now, but can't see the tables in table view. What commands did I use to hide the table name originally?
-
1 Attachment(s)
right click on Navigation Pane Heading and choose Navigation Option, then
Attachment 31405
or using VBA:
Code:
Dim db As DAO.Database
Dim td As DAO.TableDef
Set db = Currentdb
Set td = db.TableDefs("yourTableName")
td.Attributes = 0 'dbHiddenObject, will hide your table
set td = Nothing
set db = Nothing