Is there any way to encrypt the information in an Access 2003 DB?

jaffa

Member
Jan 26, 2005
170
0
0
I have a database on my webserver containing a table with two columns called username and password. I want these two columns to be encrypted, that is when a user registers his or her information shouldn't be stored in plain text (I guess).

Is there any way I can encrypt this information so that a person that manages to get into my database via the internet can't read the contents of these columns without problems?

I use ASP for my server side programming if that information affects the answer to my question.

I have googled for an answer but haven't found any useful info.
 

Zugzwang152

Lifer
Oct 30, 2001
12,134
1
0
This is PHP's version of the kind of function you'll need. the md5 function is a one-way hashing into a string of X number of characters. Use ASP's equivalent to "scramble" the username and password to put into the database (Access may have something built in as well).

When checking if the user/pass matches during a login, hash the user input again. if the hashes match, they logged in successfully.