Encryption

[shariefoo]

Hi, I know this may sound strange but is there a way to Encryption data in the table ???

thanx

 

[FoFa]

Do you want certain columkns encrypted, the whole table encrypted or the DB? How secure do you want this?

 

[shariefoo]

Actually i want the data in the table encrypted. When someone access the table i want him/her to see nothing but garbage..

Simple Security

 

[pono1]

You can use Access security or perhaps adapt one of these simple encryption algorithms or search the web for other algorithms -- say AES or Blowfish or CryptoAPI -- if you're looking for a little more muscle. I suspect FoFa has something up his sleeve too...

Regards,
Tim

 

[FoFa]

You maybe better off writting a couple functions, one to encrypt and one decrypt, strings. Use these to put and get the data from the table. Access has no built in way of doing what you want. It is a lot of work however. Have you considered just using Access security instead? If it is on a network, you could use a combination of Network and Acess security. I think what you are going to find is that it is more a problem than it is worth. Can you image what it would take to do a search, you have to encrypt the search string, search for the target, than decrypt the target when found.