How to Hide MSys System Tables in Microsoft Access
Question details
The user needs to remove MSys system tables from their view in a Microsoft Access database because they are currently visible and cannot be deleted.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Cleaning up the Navigation Pane and managing database object visibility.
- Observed behavior
- MSys system tables are visible in the Navigation Pane and trigger an administrative privileges error when attempting deletion.
Before modifying your view settings, understand that MSys tables are critical system components required for Microsoft Access to function properly. Never attempt to delete them; instead, simply hide them from your view.
Hide System Objects via the Navigation Pane
The quickest method to hide MSys tables is by adjusting the Navigation Options directly from the Navigation Pane context menu.
Every Access database normally contains these system tables. They are similar to components in a car engine: you do not normally see them, but the system needs them to function.
Right-click the top bar of the Navigation Pane on the left side of your Access database screen.
Click on 'Navigation Options...' from the context menu that appears.
In the Navigation Options dialog box, locate the 'Display Options' section in the bottom left corner.
Uncheck the box next to 'Show System Objects' and click 'OK' to apply the changes. The MSys tables will instantly disappear from your view.

Hide System Objects via Access Options
You can also manage the visibility of system objects through the main Access Options menu if the Navigation Pane is collapsed or unavailable.
Discover WPS Office for Your Daily Document Needs
While Microsoft Access is a specialized tool for complex database management, WPS Office provides a free, lightweight, and highly compatible suite for your word processing, spreadsheets, and presentation needs without the heavy subscription fees.

Frequently Asked Questions
What are MSys tables in Microsoft Access?
MSys (Microsoft System) tables are internal tables automatically created by Microsoft Access. They store critical metadata, configuration details, and structural information necessary for the database engine to operate properly.
Why do I get an error when trying to delete MSys tables?
Because MSys tables are essential components of the Access engine, the system protects them. Deleting these tables would corrupt your database, which is why Access enforces administrative privilege restrictions to prevent their removal.
Will hiding the MSys tables affect how my database works?
No, hiding these tables only removes them from your view in the Navigation Pane to reduce visual clutter. The database engine will continue to utilize them in the background with zero impact on functionality.
How can I view the MSys system tables again if needed?
You can reveal them at any time by right-clicking the top of the Navigation Pane, opening Navigation Options, and re-checking the 'Show System Objects' box under Display Options.




