Data encryption

[DaveButler]

For security reasons, I need to encrypt the data in a particular column. Is there a built-in routine or some simple method to achieve this? The app will have an encryption key available for the encryption/decryption.

Thanks!

 

[SgtJarrow]

If you just want to hide the data, you can set the InputMask property in the table and the data will be masked by asterisks...Not very secure, but it will mask them.

I have a string of code that will encrypt/decrypt a string that could be used for this. You could call an update query from some VB code to encrypt the field in every record and then call the code again to decrypt the field when needed....

You will just need to find some way to secure the encrypter/decrypter......maybe a password protected button or something....that is for you to decide...

Send me an email to the address in my sig block and I will forward you a sample database with this all set up.....

Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[DaveButler]

I don't want to simply hide data on the screen. I want to store encrypted data in the database. Thus, if you saw the data from Access' Table view, you'd see garbage in the cells with encrypted data. In order to decrypt the data, you would need the encrption key (i.e. password) and the encryption algorithm. It's the latter that I'm looking for -- hopefully inside a slick off-the-shelf package that can be called from VBA within Access. I don't see where Access or VBA has this native capability. Any ideas about where I can find such a routine?

 

[SgtJarrow]

Again, as stated in mys econd paragraph, I have a set of code that will encode/decode anything you want....

I put together a sample database, so you can see it in action...send me an email to my address below and I will forward it to you.....

I think you will find it will do exactly what you are looking for.... Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com