Office Settings & Configuration

Hide Table Tools, Navigation Pane, and Design Features in Microsoft Access

Phi Hung VoPhi Hung Vo Nov 13, 2026 868 views

Question details

The user wants to limit access to table tools, object properties, and Design view in a deployed Access database.

Hide Table Tools, Navigation Pane, and Design Features in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
Deploy a database with forms for data entry while keeping design features out of the normal user interface.
Observed behavior
Users can access database objects and design features that the database owner wants to hide.
Before you start

Identify the form or switchboard users should see at startup and make sure it provides the data-entry functions they need. Keep the editable ACCDB available for future design changes before creating an ACCDE.

Solution 1Recommended

Hide the Navigation Pane and ribbon at startup

Use these settings to remove common entry points to database objects and design commands from the user interface.

1
Hide the Navigation Pane

Open the database, select File > Options > Current Database, and clear Display Navigation Pane.

2
Set a startup form

In File > Options > Current Database, choose your data-entry form or switchboard in the Display Form list, then close and reopen the database to apply the startup settings.

3
Hide the ribbon

In the startup form's On Open event procedure, add the VBA command DoCmd.ShowToolbar "Ribbon", acToolbarNo. This hides the entire ribbon when the form opens.

4
Test the user workflow

Reopen the database and use the startup form to check that users can enter data without opening tables directly.

Hide the Navigation Pane and ribbon at startup
Hidden controls are not security: Hiding the pane or ribbon does not prevent a determined user from accessing database objects. Startup options can also be bypassed unless additional controls are in place.
Free Microsoft Office alternative

Work with Office documents in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday documents, spreadsheets, and presentations. It does not replace Microsoft Access or enforce Access database restrictions.

Use a familiar interface for everyday office tasksOpen and edit Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXWork with spreadsheet data when a full Access database is not requiredMove common Office files into a lightweight suite
microsoft office alternative - wps office

Frequently Asked Questions

How do I hide the Navigation Pane when an Access database opens?

Select File > Options > Current Database, clear Display Navigation Pane, and close and reopen the database.

Can I hide the entire Access ribbon from a startup form?

Yes. Add DoCmd.ShowToolbar "Ribbon", acToolbarNo to the startup form's On Open event procedure. To show it again, use DoCmd.ShowToolbar "Ribbon", acToolbarYes.

Does an ACCDE prevent users from changing table designs?

No. An ACCDE protects form and report designs and VBA source code, but table access and design require separate controls.

Are hidden Access controls enough to secure a database?

No. Hiding the Navigation Pane or ribbon changes the interface but is not an access-control mechanism. For stronger control over data and table structures, use a server-based data source with appropriate user permissions.