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?

Who is Participating?
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
What version of Acess?

Open the database in exclusive mode then:

Access 2010/2013
File tab > Info > Encrypt with password
Ganesh Kumar ASr Infrastructure SpecialistCommented:
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 DanekeTrainerCommented:
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.
LillyCAuthor Commented:
Thank you, my version is 2010.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.