Thanks.
[top-posting corrected]
You could try using Google with search words "encryption vba". I found
this link that way, for example:
http://www.di-mgt.com.au/crypto.html
I want to encrypt and decrypt field value.
I don't find it using Google.
Thx.
[It's easier to read the messages in the order they were written, so I
have placed your answer at the bottom here.]
There is no built-in encryption function in Access that I know of. If
there were, what good would it be? Anyone using the built-in
decryption would be able to decrypt what was encrypted with the same
function.
If you are worried about unauthorized access to sensitive data, you
will need to implement Access user-security features. You could also
set up a password for the database, but there are hacks out there on
the internet which will crack them in a few minutes or even seconds.
Of course, to do this properly, you'll also need to create an MDE file
from the MDB file so that nobody can open the VBA modules containing
the encryption and decryption functions (which YOU must write using
VBA code). The algorithms presented in the link I gave you will give
you a good start.
Encrypting the entire MDB file might also be an option. You could
check out the open source encryption package PGP.
