AES in Access

%3CLINGO-SUB%20id%3D%22lingo-sub-3240388%22%20slang%3D%22en-US%22%3EAES%20in%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3240388%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20with%20implement%20AES%20code%20in%20Access%20(%20I%20don't%20have%20a%20knowledge%20about%20access%20but%20I%20got%20an%20order%20for%20my%20boss%20that%20I%20must%20do%20encryption%20database%20of%20our%20company).%20Could%20someone%20help%20me%20step%20by%20step%20how%20can%20I%20implement%20found%20code%20to%20access%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3240388%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eaccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello!

I have a problem with implement AES code in Access ( I don't have a knowledge about access but I got an order for my boss that I must do encryption database of our company). Could someone help me step by step how can I implement found code to access?

6 Replies

@casillasek12 

it would just make your db, heavy.

imagine when you open the table, you need to decrypt the content when reading.

and encrypt it again when writing.

 

what if the power went off while the data is decrypted, any body can view it.

also this is not suitable for multi-use environment.

I know why the boss would like to can encryption but I can't do it. I was looking for any guide in the internet but unsuccessfully ( I found only a script VBA AES). Can you have any information how I can implement script in access?

@casillasek12 

I've not implemented AES encryption but I have used RC4 encryption in numerous apps.

RC4 is 2-way encryption so it is less secure than AES which is 1-way.
However, whilst RC4 would not be considered secure enough for e.g. credit card data, it is secure enough for any data likely to be stored in Access and is also easier to code, Decryption is instantaneous and there are no issues using this in a multi-user environment as decryption is carried out at form level. The actual data remains encrypted


Have a look at these articles as a starting point:

https://www.isladogs.co.uk/improve-security-2/

https://www.isladogs.co.uk/encrypted-split-no-strings/

 

Thank you for your time and help! I can read this atricles and if I have any question I can write here. Thnak you!
single form? how about continuous or datasheet?
Both work fine