Encrypting A Table Filed

[Eranka]

Hi



I know that a access table field can be changed to password to show as ****** but i would like to know whether is there is a way to encrypt a table field other than previously mentioned way?

[Micron]

AFAIK, you would have to write your own encryption routine or use one that's been published already. It involves replacing a regular character with one from the extended ascii set. Is this the sort of thing you're referring to?

[isladogs]

Yes it's possible in much the way micron suggested.
For example, although it's generally best to avoid storing passwords in databases, in some cases I need to do so .... but always encrypted.
This involves using an algorithm with an encryption key.
I have two methods:

a) cp/ucp - to encrypt / decrypt respectively which for simple strings involve simple character shifting
For example: cp("Eranka") => Kxgtqg ; ucp("Kxgtqg") => Eranka

Not very difficult to decode.
However make the string slightly more complex & it works far better
cp("Eranka123") => N{jwtj:;<
cp("Eranka1234")=>O|kxuk;<=>
cp("Eranka1234A")=> P}lyvl<=>?L

See if you can decipher the code
Try cp("Ridders52") as a challenge!

b) RC4 - which provides stronger encryption based on a larger character set but also needs more complex coding
Here are a few examples

Password	Pwd
ƪ8"Ž	metals
ʬ>:”J4	acrylicss
“ÿ+"“L3	80garnet
æ‡.·	MHGPZJ
Ø®!. Ì	sammy1
ܪ?7“H#šuC	westonadam44
ê¼$+‘EqM	Ashholl66
Ù®('ŽA	raddish

Notice that identical letters aren't encrypted the same and the length of the encrypted version isn't identical to the original string
For obvious reasons, I don't intend to post the code for either method here.
Send me a PM or email me if you want to know more