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
Microsoft Access
Last Comment
LillyC
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.
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.