How to Remove a Password From Access

By Nina Nixon

The longer an Access database has been stored, the greater sense it makes to reset it with a new password. Just the sheer notion of wanting to remove this security key indicates that the data must be of some value, or else you would delete the file, right? Additionally, if the records have been compromised, or if they are even suspected of being tampered with, you are validated in removing the transparent password.

Things You'll Need

  • Microsoft Access database software, Version 2000 or later

Step 1

Open the MS Access software and select "File," and then choose "Open" from the toolbar menu.

Step 2

Press the down arrow next to "Open" located beside the File Name text box, and then choose "Open Exclusive."

Step 3

Select "Tools" from the toolbar menu, and then pick "Security" and "Unset Database Password."

Step 4

Type in the password and click "OK" to remove it from the database file.

Tips & Warnings

  • Opening up the file by selecting "Exclusive" located in the Open dialog box is the only way to change the database password. You must already know the password before you can remove it.