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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.