CRYPTING TABLE

[Lengliz]

Hi,
I have a table USER.DBF where i store passwords and confidential data. I want the table to be crypted so not authorised person can't browse it using VFP.
I am using VFP6

Thank You
Mistral

 

[Mike Gagnon]

A simple way to do this, without the use of API calls, use STRCONV() to change the passwords in your table. And convert it back when needed.

cExpression = 'password'
?STRCONV(cExpression, 13)  && gives you this value cGFzc3dvcmQ=
Var1 = 'cGFzc3dvcmQ='
?STRCONV(var1, 14)  && gives you 'password'

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Lengliz]

Thank you

 

[darrellblackhawk]

If you're using XP or Win2k/2k3, you can use the builtin
encryption.

Right click on the file or folder that you want to encrypt,
select properties, click the advanced button, and check the
box labeled: "Encrypt contents to secure data".

The file or folder will be encrypted with the currently
logged in users' credentials.

Only the encrypting user/account will have access to the
file after that.

Darrell