Remove the Password and BankAccount fields

The unencrypted Password and BankAccount fields are no more required in the EmployeeDatabase.mdb database. In this solution we will become to know how to remove these two fields from the database.

1. In Microsoft Access XP, open the database EmployeeDatabase.mdb.

2. In the Database window, choose the table Employee and click Design on the Database Window toolbar.

3. Select the Password field’s row selector, and click Delete Row on the Microsoft Access toolbar. Microsoft Access will then ask you to confirm that you really want to delete the row and all the data it contains. Click Yes.

4. Select the BankAccount field’s row selector, and again click Delete Row on the Microsoft Access toolbar. Again, click Yes in the dialog box that raises you to confirm the field deletion.

5. Click the Save button on the toolbar to save the table changes. The new table design should look like the following example:



If someone is come across over your shoulder while you’re logging on to the employee management system, that person may be able to read your password as you type it. Windows Forms has the capacity of hiding the password as you type it.

The following illustration explains the steps needed to hide the password.

1. In Visual Studio .NET, open the project CH01_Encryption\EMS\ Start\EMS.sln.

2. Open the form frmLogin.vb in the Windows Forms designer.

3. In the form designer, select the password field txtPassword.

4. In the property browser, find the PasswordChar property, and change the value to *.

After you finish these steps, the password entry field will emerge as a series of asterisks instead of text, as shown here: