How to Prevent Users from Editing Tables in Microsoft Access
Question details
The user wants to stop end users from directly opening and editing backend tables and queries within a Microsoft Access database.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Securing a shared database so that users interact only with designated interfaces rather than raw data.
- Observed behavior
- Simply hiding the tables and queries in the Navigation Pane does not provide real security, as users can still double-click to open and modify the records directly.
Before making structural security changes to your Access database, ensure you have created a backup copy of the database file (.accdb) so you can safely revert any restrictive settings if you lock yourself out.
Hide the Navigation Pane and Restrict Access via Forms
The standard best practice in Microsoft Access is to prevent any direct interaction with tables by hiding the entire Navigation Pane and forcing users to interact with data through forms.
Hiding individual tables is insufficient because users can easily enable 'Show Hidden Objects'. Disabling the entire Navigation Pane and setting a startup form ensures users only see what you allow them to see.
Build data entry forms for all the tables that your users need to interact with. You can set specific 'Read Only' or 'Allow Edits' properties directly within the form settings.
Go to 'File' > 'Options' > 'Current Database'. Under the 'Display Form' dropdown, select your main menu or dashboard form to ensure it opens automatically when the database launches.
While still in the 'Current Database' options menu, scroll down to the 'Navigation' section and uncheck the box for 'Display Navigation Pane'. Click 'OK'.
In the same menu under 'Application Options', uncheck 'Use Access Special Keys' to prevent users from pressing F11 to unhide the Navigation Pane.

Split the Database and Distribute an Executable Frontend
Splitting the database separates the tables from the application logic, adding a significant layer of security when distributed correctly.
Need a Lightweight Alternative for Your Daily Office Tasks?
While WPS Office does not include a direct equivalent to Microsoft Access for complex database management, it is a highly efficient, free alternative for handling Word, Excel, and PowerPoint files. If you are managing simple datasets in spreadsheets, WPS Spreadsheet offers robust data protection and cell-locking features.
- 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Open Your Files: Easily open your existing Microsoft Office documents, spreadsheets, and presentations without losing formatting.
- 3. Secure Your Data: Use the built-in 'Protect Sheet' feature in WPS Spreadsheet to prevent users from editing specific cells or formulas.

Frequently Asked Questions
Can I set a password for specific tables in Microsoft Access?
No, modern versions of Microsoft Access do not support setting passwords for individual tables. You can only encrypt the entire database file with a password. To restrict table-level access, you must use customized forms and hide the Navigation Pane.
How do I unhide the Navigation Pane if I need to make administrative edits?
If you have hidden the Navigation Pane but need to access the tables yourself, you can usually unhide it by pressing the F11 key. If special keys are disabled, hold the 'Shift' key while opening the database to bypass the startup settings.
Why are my hidden tables still accessible to other users?
Simply right-clicking a table and selecting 'Hide in this Group' only masks it from view. Users who have 'Show Hidden Objects' enabled in their Navigation Options can still see and double-click them. This is why completely disabling the Navigation Pane is the recommended security method.
Does saving the database as an .accde file protect my tables?
Saving as an .accde file compiles your VBA code and prevents users from modifying form or report designs. However, it does not lock the tables themselves. You must still hide the Navigation Pane to prevent users from directly accessing and editing the table data.




