Encryption/Decryption challenge

[AlaskanDad]

I'm asking anyone out there:

Is there a need for a encryption function in any databases that you've worked on? It would look like this:

= Scramble([TheTextYouNeedScrambled])

which would result in something like this:

¢§ž±©ž§¬¢¯žY¬­š

Unscrambling would be easy:

= UnScramble([TheTextThatGotScrambled])

I started thinking about whether it could be done so I did it. Now I don't know if it is useful or not.

Time on my hands equals need for mental gymnastics.

 

[Lynsey]

It depends on how it would work. I have worked on a database where it is on the internet but also there was secure information in it ..... Of course I took out the confidential stuff and made a new design ... but if it could be guaranteed to be 'safe' AND it could restrict users looking at the data I reckon it may be of use. As you know access is not the 'safest' database in the world and I tend not to trust it with sensative information. If you could prove otherwise you would be onto a winner I reckon

 

[RpbertS]

I think it could be of use definetly could I see the function? I'd like to test it

 

[AlaskanDad]

It's lengthy. Drop me an email with your return address and I'll send it to you. I'd rather not post the whole thing here.