Quick summary
Setting object permissions in Microsoft Access involves opening your database in Exclusive mode and applying password-based encryption to prevent unauthorized access. This step-by-step process lets database owners control who can open and interact with sensitive Access files.
Steps
- Open Microsoft Access but do not open the database yet — click Open.
- Under the Open category, select Browse to locate your database file.
- Select the database file you want to protect, click the arrow next to the Open button, and choose Open Exclusive.
- After opening the database in Exclusive mode, navigate to File.
- Click Info in the left-hand menu.
- Choose Encrypt with Password to open the password dialog.
- Enter a password to protect the database from unauthorized access.
- Confirm the password by entering it again, then click OK to apply the password encryption.
- Close the database and reopen it to verify the password works — you will be prompted to enter the password each time the database is opened.
