Results 1 to 11 of 11
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Hide Access table, queries, forms


    How to hide Access table, queries, and forms.
    I read that you can put Usys as a prefix of the object and the system will hide it but how do you unhide it in when it gets hidden like this ?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Right click on the navigation pane header > Navigation Options > Show System Objects

    However most developers would hide the Navigation Pane in project settings as well disable right click shortcut and function keys. However, holding shift key while opening db will bypass these settings.

    You can selectively set objects as hidden.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Thanks for the good and detailed information. How can we selectively set object as hidden, what is the difference between this way vs using Usys prefix and un-checking the show system objects ?

    Sorry for my Qs just want to see which way is the most secure.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Right click on an object > Hide in this group. Then change navigation pane option setting to not display hidden objects.

    I've never done either so have no viewpoint.

    The only time I created a USys table was to create custom ribbon. I was following instructions of a tutorial.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    alright, thanks for the information.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Recommend you hide the items individually and don't use USys prefix
    It is bad practice to show system tables - USys/MSys - unless you have a reason to look at them
    As June7 mentioned USysRibbons is created when you make one or more custom ribbons
    There are about 15 MSys tables which are needed to make all databases work - most cannot be edited or deleted - leave them all alone unless you know what you are doing.

    I often hide various objects (tables/queries etc) for a number of reasons
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Sorry wrong thread.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    ridders52,

    Thanks for the valuable information.
    I understand, but I think I will do it with the Usys since if I unhide the system ones I know which one is mine since I know which table I created. I won’t delete other system table. But good to know.
    It’s a tough decision to make, I think I can do either, the system or not system and just hide and don’t show the hidden table (non system).

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Your choice but I really think it is the wrong choice.
    It is very easy to hide tables.
    There is no advantage to using USys instead and showing system tables is not a good idea
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    The only advantage of putting in Usys format and hiding system table is that it makes it harder and discouraged user to go and play or do something to the tables or codes.

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Really? Why? USys tables ARE editable.
    If users have access to the navigation pane & want to mess around they can do so whether its USys system table or a 'standard' hidden table.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Lock Access certain table, queries and forms
    By johnseito in forum Access
    Replies: 7
    Last Post: 05-20-2018, 09:05 AM
  2. Hide Access and show only my forms
    By mortenskipper in forum Access
    Replies: 8
    Last Post: 01-20-2016, 08:21 AM
  3. Replies: 3
    Last Post: 01-08-2014, 06:37 PM
  4. Replies: 1
    Last Post: 03-08-2012, 08:34 AM
  5. Replies: 6
    Last Post: 08-05-2010, 04:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums