It is always a good idea to password-protect or encrypt a
database especially if it contains some secret information. Encrypting or
password protecting a database helps to ensure that the database is secured to
prevent malicious intruders from gaining access into the database, thereby
ensuring data security. It is always a good advice to first learn how to
decrypt or unprotect a database before you encrypt a database. Protecting a
database is the process of shielding or securing a database from unauthorized
users or persons with a secret code known as password.
This is part 2 of chapter 8 of the Free Online Access Tutorial Series at Microsoft Tutorial website. In this part, I will explicitly explain how password-protect and unprotect a database in MS Office Access.
HOW TO PASSWORD PROTECT A DATABASE IN MS ACCESS
Below are the step by step guide to secure a database in Microsoft Access with a password.
To Password-protect a
Database in MS Access:
1. Load MS Access into your pc memory. Close the database if it
already open. Then click File > Open. This prompts the Open dialogue box.
2. Specify the location of the database you wish to open and
select the database name.
3. Click the drop down menu beside the Open button and select Open
Exclusive from the resulting options as shown below. Access opens the
database in exclusive mode.
NOTE:
The above three steps are used to open a
database in exclusive mode.
4. Click the File tab
and then click Encrypt with Password.
Optionally, you can add the Set Database
Password command icon in the Quick Access toolbar, where it will be easily
accessible.
5. To add the Set
Database Password command icon to the Quick
Access tool bar: click the File tab
> Options. From the Access Options dialogue box, click Quick Access tool bar from the extreme
left section of the dialogue box. Then click the Choose command from: drop down menu and select Commands Not in the Ribbon option from the resulting menu list.
Then select Set Database Password from
the sub-options and click the Add
>> button to put it in the Quick Access tool bar. Finally click Ok as shown below.

MS Access adds the Set
Database Password command icon to the Quick
Access toolbar.
NOTE:
You can further customize the Quick Access toolbar by adding
some frequently used command in it simply by selecting the command from the Access Options dialogue box.
6. Click the Set
Database Password command icon from the Quick Access toolbar located above the tab bar as shown below.
7. This prompts the Set
Database Password dialogue box. Type in the password you wish to use to
secure the database and re-type it for verification. Then click OK. A warning dialogue box displays.
Click Ok to exit it.
So anytime you or anyone else try to open this database, MS
Access will demand for the password. Make sure you use a code you are very
familiar with so that you won’t forget it.
HOW TO UNPROTECT MS
ACCESS DATABASE (REMOVING THE PASSWORD)
For some reasons, you might want to change or remove
(decrypt) the password from a database you previously password-protected.
Un-protecting a database is the process of removing or un-setting a database
password. Note that you must first open a protected database before you can be
able to un-protect it. This means that you must know the password of the
protected database before you can remove the password. You can also change the
database password using the procedure below.
To Remove or Change A
Database Password:
1. Open the database exclusively (in exclusive mode) using
steps 1 to 3 listed above.
2. Click the File tab
and select Decrypt Database.
Optionally, when you encrypt a database, the label in the Set Database Password in the Quick
Access toolbar changes to Decrypt
Database. So click the Decrypt
Database command icon.
3. This prompts the Unset Database Password dialogue box. Type the former database
password and click OK as shown below.

NOTE:
To change the password of a protected or
encrypted database, you will have to decrypt or remove the database password
using the above procedure and then encrypt it again using the new password.
Was this tutorial helpful to you?
Inform your friends about this post by clicking the share button below. Comment below if you are hooked up along the installation process.
Also click Here to subscribe for free so that you will get our latest game updates in your email.
Recommended Entrepreneurship Books
The Passionate Entrepreneur’s Strategies: Learn how to discover business ideas that will be successful, grow multiple online income streams, make money from home, attract new and retain customers, applications of SWOT analysis in any business, skills that will help you succeed as an entrepreneur, self-discipline, etc. Lucrative Business Ideas Series Book 1. By Buzzer Joseph. Read more about the book.
How to Make Money from Blogging and Affiliate Marketing: Learn the Step by Step Guide of Creating, Growing and Optimizing your WordPress Blog from Scratch for Search Engines (SEO) and How to Make Money through Google AdSense, Affiliate Marketing and Other Strategies for Earning Passive Income Online. Lucrative Business Ideas Series Book 2. By Buzzer Joseph. Read more about the book.
How to Make Money Self-Publishing Kindle Books for Beginners: Learn the Step by Step Guide to Self-Publish a Best Selling Book on Amazon KDP, How to Design Book Covers with Adobe Photoshop, Format, Edit and Proofread your Book Manuscript with Microsoft Word, Promote your Book on Various Online Platforms and Earn Monthly Passive Income Online. Lucrative Business Ideas Series Book 3. By Buzzer Joseph. Read more about the book.
Complete Solar PV System Installation Guide: DIY guide on how to install grid-connected and off-grid solar PV systems, how to build solar-powered electric cars, convert conventional cars to electric cars, online and offline ways to make money from solar energy sector (including stocks), electrical wiring and protection system installation guides, plus free resources for skill acquisition and personal development. Lucrative Business Ideas Series Book 4. By Buzzer Joseph. Read more about the book.
How to Make Money from Crypto Trading and Investing for Beginners: Step by step guide with screenshots on the basics of blockchain technology, bitcoin and altcoins, crypto security tips, cryptocurrency market analysis (FA and TA), long term and short term trading, how to calculate your profits in excel, legit ways to make money with cryptocurrencies, DeFi yield farming and staking, how to use any centralized and decentralized exchange platform and more, plus crypto investment bonus! Lucrative Business Ideas Series Book 5. By Buzzer Joseph. Read more about the book.
Blockchain Practical Guide: Step by step guide with pictures, on how to monetize the latest blockchain technology trends: crypto trading and tools, especially Ethereum, DeFi, Staking, NFTs, Top 100 Play-to-Earn (P2E) and NFT games, Web 3.0, Metaverse, Virtual Reality (VR), Augmented Reality (AR), blockchain job opportunities, with crypto investment bonus! Lucrative Business Ideas Series Book 6. By Buzzer Joseph. Read more about the book.
How to Make Money with Blockchain Web3 Apps: Step by Step Guide with Screenshots and Videos on How to Make Money from Blockchain and Web3 Projects – NFTs, Play-to-Earn (P2E) Games, Move-to-Earn (M2E) Apps, Watch-to-Earn (W2E) Apps, SocialFi and GameFi Apps, with crypto investment bonus! Lucrative Business Ideas Series Book 7. By Buzzer Joseph and Kelly Joseph. Read more about the book.
No comments:
Post a Comment
WHAT'S ON YOUR MIND?
WE LOVE TO HEAR FROM YOU!