Securing a database using a password

Protect the 'integrity and confidentiality of data is a fundamental requirement for anyone having to deal with a computer system. In this article we will see how to protect our database from interventions, manipulations or, more simply, from the prying eyes of unauthorized persons. To this end we will see how to access a selection by drawing up a password on our MS Access database.

In Access 2007 is available encryption tool. It can prevent access to data in a database, forcing users to enter a password. The procedure that we will perform, is applicable only to the database file format. Accdb.

The first step is to open a file. Accdb, Just click the Office button and select the Open item from the Office menu, as shown below:

This will open the Open dialog box of the command (shown below), in which we select the database to open, and then click on the black arrow beside the Open button, bottom right: Clicking on the black arrow, shown in the image above will open a submenu containing the following items:

• Open
• Open Read-Only
• Open Exclusive
• Open read-only access to only
• Show previous versions

Among the items previously listed choose Open Exclusive mode, which is nothing but a type of data access in a shared database on the net.
The moment you open a database in Exclusive mode prevents other users to access them. This preventive measure is useful to ensure that the database is ready for encryption.

At this point, after opening the database, select the Database Tools tab, and in the Database Tools group, double-click the item "Encrypt with Password", as shown below:

In the dialog that opens enter a password and then ricopiamola check box, as shown below: At this point we just have to press OK to confirm.

• <<
• 1
• 2
• >>