Encrypt BackEnd

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Encrypt BackEnd

Post by burrina »

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?

User avatar
HansV
Administrator
Posts: 78410
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Encrypt BackEnd

Post by HansV »

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
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Encrypt BackEnd

Post by burrina »

Ok, Thanks. I have both but wanted a second opinion.