
Exclusively open your Access database: Click on the open folder icon, select your database (.mdb) file, click the arrow next to Open button, and then select Open Exclusive. The Password Required dialog will pop up, enter the database password and click on OK.Ģ. Click on Tools → Security → Unset Database Password.ģ. Enter Access database current password, click on OK. The Access DB password has been removed, and it will be opened without password the next time. Remove database password from Access 2007ġ. Open Access database for exclusive use: Click on the folder icon, select Access database (.accdb) file on the Open dialog.

Click the arrow next to Open, and select Open Exclusive. When the Password Require dialog comes up, enter the database password, and click on OK.Ģ. Click Database Tools → Decrypt Database.ģ. On the Unset Database Password dialog box, enter current password, click on Ok. Remove database password from Access 2010Ģ. On the Open dialog, select your Access DB file, click the arrow next to Open, and select Open Exclusive.ģ.


This protection cannot fully secure the file from brute-force password attacks, so remember to set complex passwords created by password generators. The only person who knows the password can view or modify your file.

Microsoft Excel allows protecting a file from being opened by unauthorized users. People use Excel spreadsheets to manage data, analyze information, create reports, and perform other tasks. Microsoft Excel is the world's most popular spreadsheet software used in finance, statistics, science, and other fields.
