The Account and Password You Entered Cannot Be Used to Access This File Please Try Again

Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More than...Less

When you desire to help prevent unauthorized employ of an Access database, consider encrypting the database by setting a password. If y'all know the password for an encrypted database, y'all can also decrypt the database and remove its password. This commodity explains how to encrypt a database past using a database password, and how to decrypt a database and remove its password.

In earlier versions of Admission, you could create user accounts and passwords using a characteristic named user-level security. This topic does not discuss user-level security, which is not available when you use the .accdb file format.

If you lot encrypt a database and and so lose the countersign, you lot will be unable to utilise the database. Yous cannot remove a database password if you do non know the password.

In this article

• Overview

• Encrypt a database by using a countersign

• Encrypt a dissever database

• Open and decrypt a database

• Remove a password from a database

Overview

The encryption tool makes your data unreadable past other tools, and sets a password that is required to utilise the database. Remember these rules equally you keep:

• The new encryption characteristic applies only to databases in the .accdb file format.

• The tool uses a stronger encryption algorithm than was used in earlier versions of Access.

• If you lot want to encode or use a password to an earlier-version Access database (an .mdb file), Access uses the Encoding and Password features from Access 2003.

Top of Folio

Encrypt a database by using a password

The steps in this section explain how to create and use a countersign to an Access desktop database.

Encrypt a database

1. Open the database in Exclusive mode.

   How do I open up a database in Exclusive mode?

   1. On the File tab, click Open.

   2. In the Open up dialog box, browse to the file that you want to open up, so select the file.

   3. Click the arrow next to the Open push, and then click Open Exclusive. The following effigy depicts the bill of fare.

      

2. On the File tab, click Info, and so click Encrypt with Countersign.

   The Gear up Database Password dialog box appears.

3. Type your countersign in the Password box, type information technology again in the Verify box, and then click OK.

   Notes:

   • Use potent passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Potent password: Y6dh!et5. Weak password: House27. Passwords should be 8 or more characters in length. A pass phrase that uses fourteen or more characters is better.

   • It is critical that you lot call up your countersign. If you forget your countersign, Microsoft cannot retrieve information technology. Store the passwords that you write down in a secure place away from the information that they assist protect.

Top of Page

Encrypt a carve up database

To encrypt a split database, you encrypt both the front-end database and the back-cease database. After you encrypt the back-finish database, yous relink to its tables.

1. Using the steps provided in the previous section Encrypt a database past using a countersign, encrypt the back-end database.

2. In the front-end database, delete the links to the tables in the back-end database, and then link to them again. Admission will prompt you for the back-cease database countersign when you relink.

3. Subsequently you lot relink the tables, encrypt the forepart-stop database by using the steps provided previously in the section Encrypt a database by using a password.

Open and decrypt a database

Every bit a reminder, make certain that you lot remember your password  — if you forget your password, there is no method by which it can be retrieved.

1. Open the encrypted database the way that you open up whatever other database.

   The Countersign Required dialog box appears.

2. Type your password in the Enter database password box, and then click OK.

Top of Page

Remove a password from a database

Note:When you remove a countersign from a database, yous can restore it at any fourth dimension (or replace information technology with some other password) by repeating the steps in Encrypt a database past using a password, earlier in this commodity.

Remove a password

1. Open the database in Exclusive fashion.

   How practice I open a database in Exclusive mode?

   1. On the File tab, click Open.

   2. In the Open up dialog box, scan to the file that you lot desire to open, and and then select the file.

   3. Click the arrow next to the Open button, and then click Open Exclusive. The following effigy depicts the menu.

      

2. On the File tab, click Info, and then click Decrypt Database. (Annotation, if you're using Access 2007 on the Database Tools tab, in the Database Tools group, click Decrypt Database.)

   The Unset Database Password dialog box appears.

3. Type your countersign in the Password box, and then click OK.

Top of Folio

Demand more assistance?

hodgescolooter1988.blogspot.com

Source: https://support.microsoft.com/en-us/office/encrypt-a-database-by-using-a-database-password-12aa0e5c-34c6-4957-af3b-b5f5cfa9a766

Share this post