How MS Access Encryption Works
Microsoft Access had no encryption capability until the release of Microsoft Access 2007. With the MS Access 2007 release, encryption is now available.
Encryption Requirements
To encrypt your access database you must use a new database format released with MS Access 2007, the ACCDB format. Differences between the original MDB format and the new ACCDB format can be found here. If you need to convert your older database to the ACCDB format perform these operations:
- Open Microsoft Access 2007.
- Click the “Microsoft Office Button”. It should be in the left hand corner on the upper left of the access window.
- Click on the “Open” option.
- Pick the database you would like to convert, and open it.
- Click the “Microsoft Office Button”.
- Select “Save as”.
- In the “Save the database in another format section”, click on “Access Database 2007″.
- Enter a filename to save the new database file to.
- Click the “Save” button, and your database will be saved in the ACCDB format.
Encrypting your database
Once you have your access database in the ACCDB format it is a trivial process to encrypt it. The procedure follows:
- Click the “Microsoft Office Button”. It should be in the left hand corner on the upper left of the access window.
- Select “Open” from the “Office” menu.
- Change the open mode from standard “Open” to “Open Exclusive” on the lower bottom right hand of the access window.
- On the “Database Tools” tab double-click “Encrypt with password”.
- A password dialog box will appear. Enter a strong password.
- Click “Ok”.
- Your database is now encrypted.
Once encrypted, MS Access will ask you for your password when you attempt to open the database. Make sure to remember your password, as your data will be inaccessible if you do not enter the correct password.
|
|
Comments
Leave a Reply
- Windows Remote Access
Windows Remote Access is a set of components which allow remote users to access centralized computing resources. Windows Remote Access consists of the following components: Remote Access Clients Computers which are running a Windows operating system creates either a dial-up or virtual private network connection to the remote access server. The remote access client can [...]...
- XOR Encryption
The XOR encryption is a simple symmetric cipher that is used in many applications where security is not a defined requirement. The XOR Operator XOR (Exclusive OR) is a bitwise operator from binary mathematics. The six bitwise operators, as defined in the C programming language, are: Operation Symbol AND & Inclusive OR | Exclusive OR [...]...
- Failed to Access Windows Installer Components
Microsoft's Windows Installer components comprise the small constituents of a program, which are installed or removed collectively. They provide a useful way to not only install programs, but also gives the user the ability to manage these programs as well. Therefore, Microsoft Windows Installer has numerous functions to improve the tasks completed by the user: [...]...
- How Vista File Sharing works
File sharing is a necessity when there is a network. Whether it is the Internet or an intranet, people are sharing files all the time. It helps businesses function at an optimum level as people can share any information they want. File sharing makes files available for others to use. This is accomplished in many [...]...
- DirecTV Access Cards
A DirecTV access card is a type of electronic card, roughly the size of a credit card, which provides programming to subscribers. DirecTV access cards may be provided to a customer along with his/her receiver box or separately, but must be activated before any programming can be used. When the user chooses a package and [...]...
i want to save the password in encrypted format in MS Access database so no one can see the actual password.
Note: I am using Classic ASP and MS Access