I was just wondering if I understand correctly that even if you encrypt the back end using Microsofts encryption someone can still break in?
For the sake of argument let's say that's true, would it be any better to use your own hash and salt?
Encrypt BackEnd
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Encrypt BackEnd
If you have Access 2010 or later and use the .accdb format, the encryption itself is strong. So if someone gets hold of the backend, it will be very difficult to break in.
But if the frontend is not encrypted, anyone who can open the frontend an who knows a bit about Access can find the password to the backend - it is stored as plain text in a system table.
See Why MS Access isn’t a Secure Database
But if the frontend is not encrypted, anyone who can open the frontend an who knows a bit about Access can find the password to the backend - it is stored as plain text in a system table.
See Why MS Access isn’t a Secure Database
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Encrypt BackEnd
Ok, Thanks. I have both but wanted a second opinion.