Encrypting an Access Database

A database can be encrypted using the standard Access menus or by writing a VBA subroutine.

provided by: 
Originally published at Internet.com


You might feel discouraged and ask yourself, "Why bother with security?" Do not despair! Fortunately, Access enables you to encrypt a database. The encryption process renders the data in the database indecipherable from data in word processors, disk utilities, and other products capable of reading text. When a database is encrypted, no one can decipher any of its data.

A database can be encrypted using the standard Access menus or by writing a VBA subroutine. In either case, the database you are encrypting must not be open. To encrypt a database using Access's standard menus, follow these steps:

Step 1:
Choose Tool | Security | Encrypt/Decrypt Database from the menu options

Step 2:
The Encrypt/Decrypt Database dialog will appear. Select the file you want tot encrypt and click OK

Step 3:
You are prompted for the name of the encrypted database. If you selected the same name as the existing file, Access deletes the original file after it determines that the encryption process is successful. It is always a good idea to back up the original database before you begin the encryption process. This ensures that if something goes awry during the encryption process, you won't lose your data.

Encrypting with Code

...

Read article at Internet.com site
Related Articles
- Locking Recordsets in Microsoft Access 2000
Don't get locked out! Have you ever had trouble knowing what is and isn't locked when working with a Microsoft Access program? VBA offers several alternative locking strategies for the developer, ranging from locking the entire database to locking one record at a time. In addition, VBA lets you control how long data will be locked. This article shows you how.
- Understanding the Microsoft Access Runtime Engine
- Using DMAIC Methodology to Enhance Information Portals
- Zen and the Art of Breaking Security - Part II
Regional Articles
- Encrypting an Access Database Alabama
- Encrypting an Access Database Alaska
- Encrypting an Access Database Arizona
- Encrypting an Access Database Arkansas
- Encrypting an Access Database California
- Encrypting an Access Database Colorado
- Encrypting an Access Database Connecticut
- Encrypting an Access Database DC
- Encrypting an Access Database Delaware
- Encrypting an Access Database Florida
- Encrypting an Access Database Georgia
- Encrypting an Access Database Hawaii
- Encrypting an Access Database Idaho
- Encrypting an Access Database Illinois
- Encrypting an Access Database Indiana
- Encrypting an Access Database Iowa
- Encrypting an Access Database Kansas
- Encrypting an Access Database Kentucky
- Encrypting an Access Database Louisiana
- Encrypting an Access Database Maine
- Encrypting an Access Database Maryland
- Encrypting an Access Database Massachusetts
- Encrypting an Access Database Michigan
- Encrypting an Access Database Minnesota
- Encrypting an Access Database Mississippi
- Encrypting an Access Database Missouri
- Encrypting an Access Database Montana
- Encrypting an Access Database Nebraska
- Encrypting an Access Database Nevada
- Encrypting an Access Database New Hampshire
- Encrypting an Access Database New Jersey
- Encrypting an Access Database New Mexico
- Encrypting an Access Database New York
- Encrypting an Access Database North Carolina
- Encrypting an Access Database North Dakota
- Encrypting an Access Database Ohio
- Encrypting an Access Database Oklahoma
- Encrypting an Access Database Oregon
- Encrypting an Access Database Pennsylvania
- Encrypting an Access Database Rhode Island
- Encrypting an Access Database South Carolina
- Encrypting an Access Database South Dakota
- Encrypting an Access Database Tennessee
- Encrypting an Access Database Texas
- Encrypting an Access Database Utah
- Encrypting an Access Database Vermont
- Encrypting an Access Database Virginia
- Encrypting an Access Database Washington
- Encrypting an Access Database West Virginia
- Encrypting an Access Database Wisconsin
- Encrypting an Access Database Wyoming
Related Articles
- Locking Recordsets in Microsoft Access 2000
Don't get locked out! Have you ever had trouble knowing what is and isn't locked when working with a Microsoft Access program? VBA offers several alternative locking strategies for the developer, ranging from locking the entire database to locking one record at a time. In addition, VBA lets you control how long data will be locked. This article shows you how.
- Using DMAIC Methodology to Enhance Information Portals
- Understanding the Microsoft Access Runtime Engine
- Zen and the Art of Breaking Security - Part II

Rss   Delicious   Digg   Add To My Yahoo   Add To My Google   Bookmark   Search Plugin

Topics:
Architecture & Design Languages & Tools Project Management Web Services
Database Microsoft & .NET Security Wireless
Java Open Source Techniques XML