We help IT Professionals succeed at work.

If I encrypt a value, will anyone With Access be able to decrypt it.

Clive Beaton
Clive Beaton asked
I had this question after viewing I need to convert a string into a string of decimals.

It was suggested I need to encrypt the value for maximum security.
Watch Question

Database Expert
Awarded 2016
Top Expert 2016
>>If I encrypt a value, will anyone With Access be able to decrypt it
Yes why not. We need an algorithm like DES, Triple DES, TRIPLE_DES_3KEY. If you write your own logic to build this then smart chaps(Hackers) will easily crack that. So basically it depends how sensitive you data is and how much security you wanted to implement. MS ACCESS will only encrypt your data but wont provide security. You need to use a database engine like SQL Server.
Encrypting data usually involves setting a password (salt), so even in someone else has the same encryption algorithm they will not be able to decrypt your data.
John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019
After the convertion you can apply hashing and compare hashed password to the stored hash....i guess this will make things more difficult
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Just to note: Access does not have any builtin encryption methods, other than setting a Database Password. However, if you know the Database Password (and you must, in order to actually work with the data), then there's little point in using this method, since entering the password will also show all data in human-readable form.

You can encrypt data BEFORE it goes into the database, of course. That can be very time consuming, and can lead to significant performance penalties. You'd have to be sure that your encryption process is run anywhere users can enter/edit data, and that your decryption process is run anywhere users access data.

As others have said, if you need true data security you should consider a different database platform. You can use Access as a front end to different database engines, with MS SQL Server being the most popular.
Clive BeatonAccess Developer


Thanks you all.  Most helpful.