encrypt a microsoft access database

hi

i have sensitive data on some microsoft access databases so i encrypt the files with veracrypt but its slow down the performance of the database significantly. i tried to use another encryption software "folder lock" but it's has the same problem. is there a software on the market that encrypt without affecting significant the performance , or maybe should i update my hardware ?

my system info:
windows 8.1 i 64 bit my processer is intel core i5-4460 cpu 3.20 ghz and 8 gb ram.
bill201Asked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Late to the Party here...
@bill201
Tough question...
Typically (but I will admit, ...not always) the "faster" the encryption/decryption, ...the less secure the encryption will be...
So if you want "Faster* encryption, are you willing to risk the security?

it's taks like a second when it's not encrypted and 2-3 second when it's encrypted.
...Well then to me, this would not seem too bad.
300% only gets bad as the time increases.
1 second to three seconds is 300 percent, ...but the difference in perception is not all that much. (Two more seconds)
However, 10 "minutes* to 30 minutes is also 300 percent, ...but the time is significantly greater. (Twenty more minutes)

So if it now takes 3 seconds to open the file, ...is that *really* a problem?
This is hardly enough time for the users to think that the app has crashed.
Are the recipients opening and closing this file hundreds of times per day, and the cumulative effect of all the two second delays is becoming meaningful?

As the others have stated, ...It takes time to encrypt/decrypt
So are you looking for a *secure* encryption method, ...or a *fast* one.

All encryption methods are not created equal.
It is not that they are all exactly the same, and some are just "faster"
So even if product X claimed to be "just as secure as" Product Y, ...but faster, ...how would you verify the "Just as secure" claim?
Typically the Security aspect of an encryption method is only discovered when a security breach occurs, (the encryption is maliciously defeated.)
Then *Faster* becomes less of a concern.
;-)

In other words, if the fastest you can get (with the security level you need) is 3 seconds, ...then it is, what it is...
You can shop around for something faster, ...but what if it turns out to be not as secure...?

Just my thoughts

JeffCoachman
0
 
McKnifeCommented:
If you want a performance improvement, then you need to tell us how the performance is now - in numbers. What would "significantly affecting the performance" mean in numbers?
0
 
bill201Author Commented:
thanks for your comment, but what you mean in numbers, how much seconds it's take to upload?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
McKnifeCommented:
You wrote about a significant decrease in performance. How much, does it take 10% longer, or 50% longer, or 100% longer...
0
 
Monika BhartiConnect With a Mentor Sr. AnalyticsCommented:
There is always an overhead cost associated with encryption and if use any encryption then you are created an “another layer”, so when you access your database the application needs to pass through that “layer” each and every time which in effect causes the application to slow down and in your case it is affecting in terms of performance.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
If you have sensitive data, then you should really consider moving it to a more secure platform, like SQL Server. SQL Server Express is free, and has a pretty good security mechanism, which will generally remove the need for encryption.
0
 
bill201Author Commented:
i thinks it's something like 300% slower
0
 
bill201Author Commented:
but sqlserver i have to have a server, am i correct?
0
 
frankhelkCommented:
Think of a usual, but lengthy operation, something that lasts ... let's say 10 seconds on an unencrypted database. How long would that take if encrypted ?

Have you tried the Windows on-bord encryption ?

Another attempt wood be to do the encryption not on file but on data level - encrypt the data in your software when you put it into the datasets, and leave the non-critical fields unencrypted. Decrypt when reading the data.
0
 
bill201Author Commented:
Scott McDaniel

but it's a lot a lot slower not a bit slower
0
 
frankhelkConnect With a Mentor Commented:
but sqlserver i have to have a server, am i correct?

Not in every case - you could run it on your application machine like Access.
0
 
bill201Author Commented:
frankhelk
it's taks like a second when it's not encrypted and2-3 second when it's encrypted.
the windows encryption bitlocker i don't can use because my windows is a home version . and is bitlocker faster from other encryption softwares ?

your other solution to split is a little complicated but of course if there is no  any better option i will have to consider it
0
 
McKnifeCommented:
300% slower means everything takes 3 times as long? That's not expected behavior. You should try bitlocker or a hardware based encryption. With win8.1 Bitlocker does support hardware encryption, but it would mean to reinstall the OS.
0
 
bill201Author Commented:
Mcknife

I will have to purchase a new license for windows 8.1 pro or to upgrade (if it's an option) to be able to use bitlocker
0
 
McKnifeCommented:
Yes, I saw that comment (where you said you haven't bought pro) after posting.
You could also try disk cryptor. We used it on a file server after truecrypt's performance disappointed us. It was a lot faster.
If you haven't got an ssd, I would go for one, if I were you. Some feature full disk encryption without the need for additional software and you can expect to see no performance loss at all. You would only need to make sure that your BIOS supports that option.
0
 
bill201Author Commented:
I have an ssd (there I have my windows system), how can I check if my bios is supporting an encryption
0
 
McKnifeCommented:
What exact SSD model is it? That's more important.
0
 
bill201Author Commented:
Kingston v300 2.5 sata3 ssd
0
 
McKnifeCommented:
I must say kingston's documentation is not that easy to find... it seems as though this product isn't a self encrypting drive. Maybe someone else can confirm that.
0
 
bill201Author Commented:
Can you recommend for a good ssd driver that support encryption?
0
 
McKnifeConnect With a Mentor Commented:
Sure. I would choose a Samsung 850EVO, should cost you about 150USD for 250GB.
0
 
bill201Author Commented:
Jeffrey Coachman

thanks for your excellent comment, but it's so slow and annoying that  I hate working with that databases and it's not worth for me.
0
 
McKnifeCommented:
Another thing: Bill, are you perfectly sure that the encryption is even the culprit? Was that the only thing you changed between the fast and the slow state?
I'm asking because anti virus software is known for terribly affecting database performance (if not configured correctly).
We have all our DB servers encrypted and did not have such a great drop of performance, nowhere next to it.

Did you setup AV software at the same time?
0
 
bill201Author Commented:
I use eset smart security and without encryption its don't affect  the database performance. But now I think that maybe the database work slower because it's have a back end and front end on the encrypted drive and has also linked a table to another database . So its actually work with three files on once.
0
 
bill201Author Commented:
With three encrypted files on once.
0
 
McKnifeCommented:
So, what are you going to do, do you need further advice?
0
 
bill201Author Commented:
i will try to combine it back to one file and see if is solve the problem
0
 
Jeffrey CoachmanMIS LiasonCommented:
but it's so slow and annoying
it's taks like a second when it's not encrypted and2-3 second when it's encrypted.

So 1 or 2 extra seconds make this annoying?

Again, "faster" may mean "less secure"

JeffCoachman
0
 
bill201Author Commented:
thanks a lot for you
0
 
McKnifeCommented:
Let us know what it turned out to be, in the end.
0
 
bill201Author Commented:
i use vertacrypt but on a ssd drive (like you suggested),so it's  Much better than it was before,  and I learned to be more patient even it's slower, like Jeffrey Coachman wrote that slower is more security,  so in fact the answer was a combination between your answer  and Jeffrey Coachman answer , And for others also gave points for trying to help...

ahd thanks again for your kindness :)
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK Bill,

But to be clear, I said it "might" be less secure if it was faster...
;-)

There may very well be an encryption that is faster than another, yet still more secure, ...
I just did not want to see you more concerned with the speed.
;-)

Jeff
0
All Courses

From novice to tech pro — start learning today.