Consulting

Results 1 to 2 of 2

Thread: hidden table names

  1. #1

    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?

  2. #2
    right click on Navigation Pane Heading and choose Navigation Option, then
    navpane.jpg

    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
    Last edited by Aussiebear; 03-11-2024 at 11:30 PM. Reason: Added code tags to supplied code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •