Encrypt a field in Access 2000 .mdb table?

Can this be done? I have a table with possibly sensitive info in one of the fields, and I would like to be able to encrypt/decode that field's data for ftp file transfers. Thanks.
horstuffAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
Well it works in A2003, so I guess it will work in A2000.

There is a coding error in a different function which causes a compile problem.

To fix it do an Edit> replace for the whole project.
Replace CutWord with CutFirstWord

Example:
?encrypt("peter")
«­£

?decrypt("«­£")
peter


Pete
0
 
peter57rCommented:
Hello horstuff,

If simply encrypting the database is not an option then there is code in the file from the link below which will encrypt individual fields.
Of course your recipient must know how to decrypt the data.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;177972


Pete
0
 
horstuffAuthor Commented:
It says that's for 97. Will it work for 2000?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.