How to Protect an MS Access Database?

Contributor

By Tricia Goss
eHow Contributing Writer

Article Rating: (0 Ratings)

Protect an MS Access Database?

Microsoft Access is an affordable database program. Its databases are used by many businesses. Users can, and typically do, create several separate databases. These databases often contain sensitive, confidential information, such as client or member names and details, employee information and product inventory, orders or specifications. Because of the classified data, database administrator take steps to protect the information. Fortunately, Microsoft provides built-in tools to help implement database protection in Access.

Types of Databases
Both large businesses and private individuals may have a need to store lists of information that can be ca… More
What Is a Microsoft Access Database?
Microsoft Access is sold separately or as part of a Microsoft Office Suite. The current version is labeled… More
About Microsoft Access
Microsoft Access is a database management program that is generally bundled with the Microsoft Office pack… More
How to Learn Microsoft Access
Microsoft Access is a database application that is part of the Microsoft Office Suite Professional or high… More
How to Learn Microsoft Office
Microsoft Office is a very helpful program to own. It has a number of desktop applications combined as one… More
Purpose of Microsoft Access
Microsoft Access is the database management program included as part of certain Microsoft Office suites, s… More
How to Use Microsoft Office Suite
Microsoft Office is often referred to as Microsoft Office Suite. It is a widely used group of interconnect… More
How to Use Microsoft Access Query
Of all the applications in the Microsoft Office suite, Access may be the most intimidating. Once you learn… More
How to Delete or Copy a Table in Microsoft Access
Access is a powerful data management program that can be difficult to master because of its extensive capa… More
How to Use Microsoft Access XP
Microsoft Access is powerful database creation tool. You can create a database to analyze data, store reco… More
How to Use a Microsoft Access Program
Microsoft Access is the database program that is included with Microsoft's Office suite. While not as intu… More
How to Protect an MS Access Database?
Microsoft Access is an affordable database program. Its databases are used by many businesses. Users can, … More
How to Use BETWEEN in Microsoft Access SQL
BETWEEN is useful when selecting data that falls within a specific range. Learn how to use this powerful M… More
How to Write SQL Statements in Microsoft Access
You don't have to use the Select Query window in Microsoft Access to extract information from your databas… More
How to Understand Referential Integrity in Microsoft Access
You can ensure that relationships between records in related tables are valid by enforcing referential int… More

Difficulty: Moderately Easy

Instructions

Things You'll Need:

Microsoft Access 2003 or 2007

Step 1

Open the Access database to be protected. Go to the Tools menu in Access 2003, point to Security and click "Set Database Password." In Access 2007, go to the Database Tools tab, and click "Encrypt with Password" in the Database Tools group.
Step 2

Enter a password for the database in the Password box. Reenter the same password in the Verify box. Click "OK."
Step 3

Go to the Tools menu in Access 2003. Point to Security and click "User Level Security Wizard." In Access 2007, go to the Database Tools tab and click "Users and Permissions" in the Administer group. Select "User Level Security Wizard." The wizard will open.
Step 4

Select "Create a New Workgroup Information File" and click "Next." Enter the information requested by the wizard, select the database objects to protect, and click "Next."
Step 5

Select groups to include in the workgroup information file, click "Next," select permissions, if any, and click "Next" again. Add user names and passwords and click "Finish."