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

Hello

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?

Thanks
LillyCDatabase DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
0
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.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
What version of Acess?

Open the database in exclusive mode then:

Access 2010/2013
File tab > Info > Encrypt with password
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LillyCDatabase DeveloperAuthor Commented:
Thank you, my version is 2010.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.