Results 1 to 4 of 4

Thread: Hidden tables

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Angry Unanswered: Hidden tables

    Did any one create hidden table in Access?
    I created one but when the database is compressed from the Tools menu, the hidden tables will be deleted? This takes place under Office 97. Perhaps not under 2000

    What do you mean? Have any experience?

  2. #2
    Join Date
    Oct 2003
    Posts
    66
    You must enbale the option to view hidden object to see it. Go Tools Option then View Tab and check "Hidden Objects" checkbox. I use hidden tables and we compress Bdases every night and they don't delete. Hope this helps.

  3. #3
    Join Date
    Oct 2003
    Posts
    66
    Oh but we do use 2000 so ... don't know about 97...sorry didn't see last part.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Wink

    Yes, it is enabled, but the hidden tables are still not shown.

    Also try this

    If you want to hide a table in the database windows so that other users can't select it, preface the table's name with 'Usys'. For example, if your table's name is employee, change it to UsysEmployee. This makes your table into a system object which access does not display. To see this table later, choose view, options, show system objects.


Posting Permissions

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