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

Clive Beaton
Clive Beaton used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Expert
Awarded 2016
Top Expert 2016
Commented:
>>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
Commented:
After the convertion you can apply hashing and compare hashed password to the stored hash....i guess this will make things more difficult
Most Valuable Expert 2012
Top Expert 2014
Commented:
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

Author

Commented:
Thanks you all.  Most helpful.

CRB

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial