本文讲解了再ACCESS中加密文本的方法。

本文假设使用按钮点击来调用一个加解密函数来实现对文本进行加密。

Private Sub Comman1_Click() Dim str1, str2, str3 As String str1 = "王宇虹" str2 = Encrypt(str1, 188, 24) MsgBox str2 str3 = Encrypt(str2, 188, 24) MsgBox str3 End Sub

Private Function Encrypt(ByVal strSource As String, ByVal Key1 As Byte, _ ByVal Key2 As Integer) As String Dim bLowData As Byte Dim bHigData As Byte Dim i As Integer Dim strEncrypt As String Dim strChar As String For i = 1 To Len(strSource)'从待加（解）密字符串中取出一个字符strChar = Mid(strSource, i, 1)'　取字符的低字节和Key1进行异或运算bLowData = AscB(MidB(strChar, 1, 1)) Xor Key1'取字符的高字节和K2进行异或运算bHigData = AscB(MidB(strChar, 2, 1)) Xor Key2'将运算后的数据合成新的字符strEncrypt = strEncrypt & ChrB(bLowData) & ChrB(bHigData)NextEncrypt = strEncrypt End Function