Mar 02 2022 02:15 AM
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?
Mar 02 2022 03:30 AM
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.
Mar 02 2022 04:11 AM
Mar 02 2022 04:35 AM - edited Mar 02 2022 04:38 AM
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/
Mar 02 2022 04:45 AM