Log in

View Full Version : hidden table names



DBinPhilly
03-11-2024, 07:05 AM
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?

arnelgp
03-11-2024, 06:22 PM
right click on Navigation Pane Heading and choose Navigation Option, then
31405

or using VBA:


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