Others

How to Hide MSys System Tables in Microsoft Access

Huma Ashraf ChHuma Ashraf Ch Oct 29, 2026 869 views

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.

How to Hide MSys System Tables in Microsoft Access
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 you start

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.

Solution 1Recommended

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.

1
Open Navigation Pane Options

Right-click the top bar of the Navigation Pane on the left side of your Access database screen.

2
Select Navigation Options

Click on 'Navigation Options...' from the context menu that appears.

3
Clear Show System Objects

In the Navigation Options dialog box, locate the 'Display Options' section in the bottom left corner.

4
Apply Settings

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 the Navigation Pane
Essential System Components: MSys tables are standard system objects included with all Access databases. Hiding them ensures they continue to run the database engine in the background without cluttering your workspace.
Free Microsoft Office alternative

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.

Highly compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight installation that runs quickly and smoothly on most devices.Familiar user interface allowing for a seamless transition from other office suites.Free core features to efficiently manage your everyday office tasks.
microsoft office alternative - wps office

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.