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

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.
Clive BeatonAccess DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
>>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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MacroShadowCommented:
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 EngineerCommented:
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 (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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 DeveloperAuthor Commented:
Thanks you all.  Most helpful.

CRB
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.