Forum Discussion
casillasek12
Mar 02, 2022Copper Contributor
AES in Access
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 hel...
casillasek12
Copper Contributor
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?
isladogs
Mar 02, 2022MVP
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/
- casillasek12Mar 02, 2022Copper ContributorThank you for your time and help! I can read this atricles and if I have any question I can write here. Thnak you!
- arnel_gpMar 05, 2022Steel Contributorsingle form? how about continuous or datasheet?
- isladogsMar 05, 2022MVPBoth work fine