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 ?
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 ?
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.
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.
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.
alright, thanks for the information.
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
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.
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).
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
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.
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.