How does MS Access Encryption work

Microsoft Right had no cryptography capableness until the ending of Microsoft Hit 2007. With the MS Operation 2007 channelize, coding is now forthcoming. To encrypt your accession database you staleness use a new database divide released with MS Access 2007, the ACCDB formatting. Differences between the example MDB divide and the new ACCDB format can be plant here. If we need to convert our 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 file name 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 we for our password when we attempt to open the database. Make sure to remember our password, as our data will be inaccessible if we do not enter the correct password.