Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2007
    Thanked 0 Times in 0 Posts

    show hidden table (Access 2000)

    I have a command making a table hidden:
    Application.SetHiddenAttribute acTable, "customers1", True
    What will be the command to set the Show hidden table = False ?
    Also, is it posbile to have a command to make all the tables in the database hidden ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: show hidden table (Access 2000)

    To hide hidden objects (not just tables):

    SetOption "Show Hidden Objects", False

    There's no point in making all tables hidden. The user can easily set Show Hidden Objects to True again.

    Instead, specify a form as startup form and hide the database window in Tools | Startup...
    You can also disable F11 as shortcut key to unhide the database window.

    If you want to bypass the startup options as designer of the database, hold down the Shift key while opening the database.

Posting Permissions

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