How Do I Encrypt an Access Database?

Let me answer :

MD5 encryption itself has nothing to do with the database, and the encryption is encrypted in asp** itself.

There is an md5() function in .

If the password field in the database is password and in asp**, the variable that means the password is pwd

After MD5(PWD), it is the ciphertext encrypted by MD5.

Then use insert or other methods such as ado to save this ciphertext to the database. That's it.

When verifying the password, also use md5(pwd) to generate the ciphertext, and then compare it with the ciphertext in the database, if it is consistent, it means that the entered password is consistent with the database, if it is inconsistent, it does not match.

I'll answer and give **:

Upstairs it's pretty much the same.

It is to add md5: when uploading data

sql="select

fromuser

sql,conn,1,3

rs("user")="user")

rs("password")=md5("password"))

1.Load the MD5 file on the page where you want to use the MD5 encryption algorithm.

2.Use MD5 functions where you want to use them, for example:

nowusername="username")nowpwd="pwd")

sql="select * from login where username='"nowusername&"'and pwd='"md5(nowpwd)&"

Here pwd='"md5(nowpwd)&"The function is to obtain the input data and encrypt it with the md5 function, and then compare it with the record in the database to see if it is correct.

set rs=

if then

end if

You can first encrypt 123456, md5, get a 16-digit password, and then replace the original md5 password with the one you just get, then the current password will become 123456.

MD5 is irreversible, and you can try to crack it with explosive force, or use the exhaustive method.

MD5 is irreversible. You can try to encrypt your usual password with md5 and replace it in the database before logging in.

Select a common password - > MD5 encryption - > replace the ID password in the original server database.

You can do that!

Encrypt in the web leaf, and then operate the database with SQL statements, so that the ** inch into the database is over-encrypted!

Overwrite the md5 file to the database.

Too long! Can't replicate! It's the inculde md5 page, and then call it where you need to encrypt!

Mah. You go to the next one, or find a whole site program that has it!

Addendum: Confused. If you have to ask me, ** paste it for you???

This thing is not directly operating on the database. md5 is a page, do you use asp or everything else, insert this containing page in the foreground, for example, when the user registers and enters the password, you can call the function of this page, I don't understand? Some things are more learning to make by yourself than by eating ready-made!

Connecting to a database with Delphi and ADO can be achieved in the following ways:

Restore the data so that you can use the database yourself.

copyfile(pchar(app_path+'\data\'),pchar(app_path+'data\'),false);The app path represents the current directory of the program, which is an MDB file with a changed extension.

copyfile(pchar(app_path+'data\'),pchar(app_path+'\data\'),false);

'provider=;data source='+app_path+'data\;persist security info=false';Adocon is a TadoConnection component.

true;except

messagebox(handle,'A fatal error occurred when opening the database!! ','Wrong',mb_ok+mb_iconerror);

end;Encrypt it as soon as you open it.

MD5 encryption is theoretically non-decompilable, that is, irreversible, that is, once encrypted, it can never be reversed!

Because of this, the general programming language, ** system, will use this way to encrypt passwords!

If it can be reversed casually, then wouldn't the MD5 encryption password be meaningless?

But there are no absolutes in everything, you can decrypt some MD5 **, some simple MD5 encryption, or you can decrypt!

But the principle of their decryption is not the reverse of MD5's ability!

Just collect some known MD5 ciphertext and the corresponding plaintext, and when they are to be decrypted, they are used to compare whether they exist to achieve the purpose of decryption! In other words, they can't decrypt it 100%, it's just a kind of carpet search comparison!

After MD5 encryption, it cannot be decrypted in reverse, and it cannot be used to encrypt information, and it can only obtain a unique identification code.

set rs="")

select * from admin where admin='"usr & sail imitation and password='"md5(pwd)&"conn,1

if and then

State coarse fiber"elsesession("admin")=rs("admin"Here the stool chop is written to sessionend if

set rs=nothing

set conn=nothing Just encrypt the password you submitted with mdb to see if it is equal to the password of your database.

When validating, receive the form data that arrives at the time of the judgment u for example: md5("password"So that's it.

The login should be similar to what you are registering, and it is also encrypted with MD5, and after comparison, it should be possible.

Wouldn't it be nice to encrypt the password submitted by the user. Isn't it possible?