Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables

Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables

Hiding tables (or any object) in your Access database is a simple enough process. You only need to set the objects hidden property (to True) and reveal the ‘Hidden Objects’ setting from the navigation pane options screen.

But in this quick Microsoft Access tutorial here, there is another method of stopping your tables appearing in Navigation pane (or Database window) by renaming the table(s) with the prefix USYS. This will convert your table into a system object, which cannot be viewed in the normal environment.

microsoft access tutorial usys tables

In the Navigation pane’s options screen (Access 2007 & 2010), you have two display options the called Continue reading “Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables”