Avatar of LillyC
Flag for United Kingdom of Great Britain and Northern Ireland asked on

How to put 'Encrypt with password' into the ribbon in MS Access


I'm trying to set up a password but can't see the option 'Encrypt with password' in the Database Tools option in the ribbon.

I have tried adding it but I can't see this is the command options.

Can anyone help?

Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon
Ganesh Anand

You can see that under Database Tool Bar:

Open the database in Exclusive mode.

How do I open a database in Exclusive mode?

Click the Microsoft Office Button Office button image, and then click Open.

In the Open dialog box, browse to the file that you want to open, and then select the file.

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

Opening a file in Exclusive mode

On the Database Tools tab, in the Database Tools group, click Encrypt with Password.

Access Ribbon Image

The Set Database Password dialog box appears.

Type your password in the Password box, type it again in the Verify box, and then click OK.
Richard Daneke

When you encrypt your database, you must have your database open in Exclusive mode.  

Once encrypted,  the database will ask for the password each time it is opened.  

Therefore, it would seem a ribbon option is not needed since multi-user databases  are opened with a password and closed without prompting.  When a new password is desired, the Save As option will let a user (with the db open in exclusive or single-user mode) enter a new password for encryption.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.

Thank you, my version is 2010.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy