Detailed description of the Access database management password method

Guidance:InAccess DatabaseIs embedded into a very strong database operating language-Visual Basic language, so you can use Visual Basic to write programs to implement some complex functions. The following describes how to implement encryption in the Visual BASIC program to ensure data security. We can also see that the Access database manages passwords.
For some companies, employee salary management is not a big problem. Sometimes, leaders need to know the income of each employee over a period of time in order to grasp the distribution of various bonuses. To this end, I have designed a "Wage Management" database, which can be queried by time and calculated based on the selected wage category. To prevent others from viewing this database, I used the "exclusive" method to set a password for the database. This method also has some limitations. If the user happens to provide the correct Database Password, this method cannot control the user's operations on the database.

To further prevent employees from viewing the salary statistics, that is, some bonuses are not made public, and other people except leaders should not know the salary amount), I created a password table, set the password, remember to hide it, select "password table", and click "hide" in the "window" menu to hide the table ). Then, in the "employee salary" dialog box, add the "password" text box, and add the following statements during the "preview" and "print" Events:

DoCmd. ApplyFilter, "Password = Forms!
Employee Salary dialog box! PassText"
If Not IsNull ([Password]) Then
/* Other code */
Else
MsgBox "enter the correct password! "
PassText. SetFocus
End If
/* Other code */

In this way, the dual encryption function is implemented. Even if the user can access the database and does not provide the correct password for the second time, he cannot preview and print the statistical results within a certain period of time. This further limits the user's unauthorized access.
To improve database security, you should change the password at intervals. To this end, in the "Employee Salary dialog box" form, I added a "Change Password" subform, in which the following code can be added to change the password at any time

Private Sub confirm _ Click ()
On Error GoTo Err _ OK _ Click
DoCmd. ApplyFilter, "Password
= Forms! Change Password! Text1"
If IsNull ([Password]) Then
MsgBox ("the password is incorrect,
Enter ")
Text1.SetFocus
GoTo Exit _ _ Click:

End If

If Text3.Value <> Text2.Value Then

Text3.SetFocus

MsgBox ("enter the correct password ")

Else:
Password = Text3.Value
DoCmd. Close
End If
Exit _ confirm _ Click:
Exit Sub
Err _ confirm _ Click:
MsgBox Err. Description
Resume Exit _ confirm _ Click
End Sub
After changing the password, remember this password for future use.
Design the program and hide the code in the same way as hiding the "table") to prevent others from modifying or peeking. The method described here is only a small trick to implement the encryption function in the program. In other database management, this method can also be used for encryption. There may be more concise methods to be explored and communicated during the programming process.

There may be many articles about the security of the Access database. The methods mentioned above are also effective, which can ensure the security of the Access database and hope to help you.