Hide Table Tools, Navigation Pane, and Design Features in Microsoft Access
Question details
The user wants to limit access to table tools, object properties, and Design view in a deployed Access database.

- 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.
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.
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.
Open the database, select File > Options > Current Database, and clear Display Navigation Pane.
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.
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.
Reopen the database and use the startup form to check that users can enter data without opening tables directly.

Deploy an ACCDE and restrict access to the data source
Use an ACCDE to protect form, report, and VBA designs, and use data-source permissions when table access must be controlled.
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.

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.




