Encrypt and De-Crypt a table with this code

[pelopidas]

Hello form Greece.
I have found a sample (i attached in post, please see it!!!) and with this sample we can encrypt and decrypt a phrase in HEX, Blowfish and RijnDael.

This is fantastic and i want to use it do encrypt and decrypt with this code a table.

The goal i want to set is:
I want the table always being encrypted and when i want to use the data in it, with a commnd in a button for example, to decrypt it and show the data.

I have a plan in my mind but i dont know how to make a table (or a field of a table) encrypt and decrypt with this code.

I think this would be a great rutine to safe (SAFEST!!!!) databases!!!

Can any body help to show me the way?
Thanks for your time and sorry for my bad English

 

[georgedwilkinson]

If safety of your data is important, you should be using Oracle or SQL Server and set up security correctly. These power-houses have spent millions/billions of dollars on protecting data in their databases. Anything you can do would pale in comparison to what they've already done.

 

[gemma-the-husky]

i doubt if a dbs would work with encrypted data.

you can encrypt selected fields, but surely not primary key indexes etc

 

[Banana]

Not to mention that it's far easier to encrypt a data but much more difficult to implement it properly. It's very easy to think you've locked it up pretty tightly but could be surprised when an attacker just finds the key under the doormat and lets himself in!

I would second George's suggestion- if you have sensitive data, then it shouldn't be stored in Access at all. Use other RDBMS and keep the Access as front-end if you prefer.