# How to Set Object Permissions MS Access

> To restrict access in Microsoft Access, open the database file in Exclusive mode by selecting 'Open Exclusive' from the Open menu. Next, navigate to File, choose Info, and select 'Encrypt with Password'. Enter and confirm your password, then close and reopen the database to verify the protection.

Canonical: https://livedemo.ai/tutorials/how-to-set-object-permissions-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4dc1ab56e05a00ff96e9/preview?step=1

## Steps

1. Open Microsoft Access but do not open the database yet. Select 'Open'.
2. Under the 'Open' category, select 'Browse'.
3. Select the database file you want to protect. Click the arrow next to the 'Open' button and choose 'Open Exclusive'.
4. After opening the database in Exclusive mode, go to 'File'.
5. Click 'Info'.
6. Choose 'Encrypt with Password'.
7. Enter a password to protect the database from unauthorized access.
8. Confirm the password by entering it again and click 'OK' to apply the password.
9. Close the database and reopen it to ensure the password works as expected. You will now be prompted to enter the password each time you open the database.