Best way to secure Ms Access DB
-
Hello, I have a desktop software developed with VB.NET using Ms Access as backend. I want some security measuremetns vis which the data remains safe and secure - others or employees can't open or view the contents of the data. How can I achieve the same ? Any helpline, guidance is highly appreciative.
Thanks & Regards,
-
Hello, I have a desktop software developed with VB.NET using Ms Access as backend. I want some security measuremetns vis which the data remains safe and secure - others or employees can't open or view the contents of the data. How can I achieve the same ? Any helpline, guidance is highly appreciative.
Thanks & Regards,
-
Hello, I have a desktop software developed with VB.NET using Ms Access as backend. I want some security measuremetns vis which the data remains safe and secure - others or employees can't open or view the contents of the data. How can I achieve the same ? Any helpline, guidance is highly appreciative.
Thanks & Regards,
Try the link below: http://office.microsoft.com/en-us/access-help/encrypt-a-database-by-using-a-database-password-HA010096299.aspx[^]
Thanks Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
-
Try the link below: http://office.microsoft.com/en-us/access-help/encrypt-a-database-by-using-a-database-password-HA010096299.aspx[^]
Thanks Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
I had read about encrypting the DB, but for usage as a backend will have to decrypt each time I use the DB via application and the applicatio nwill be running almost the whole day. Encrypting & Decrypting huge db often is not a good idea according to me. What do you think ?
Thanks & Regards,
-
That is for sure. But their are also some who can crack the password. Thinking for protection from that prospect, I think should have somethign more solid also maybe along with password protection.
Thanks & Regards,
-
Hello, I have a desktop software developed with VB.NET using Ms Access as backend. I want some security measuremetns vis which the data remains safe and secure - others or employees can't open or view the contents of the data. How can I achieve the same ? Any helpline, guidance is highly appreciative.
Thanks & Regards,
Access is a bad production database because it is so open. Can you use SQL Express or some other for the back end? Note when you use a password on Access you open a new set of problems.
-
That is for sure. But their are also some who can crack the password. Thinking for protection from that prospect, I think should have somethign more solid also maybe along with password protection.
Thanks & Regards,
Then you can't use an Access database. You'd have to use SQL Server for better protection.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
That is for sure. But their are also some who can crack the password. Thinking for protection from that prospect, I think should have somethign more solid also maybe along with password protection.
Thanks & Regards,
You should keep the password encrypted in the configuration file for increased security. Still, as Dave said, if you have sensitive data in it, then go for SQL. You can make use of SQL express edition since that is free hence will not charge you more money. :)
-
I had read about encrypting the DB, but for usage as a backend will have to decrypt each time I use the DB via application and the applicatio nwill be running almost the whole day. Encrypting & Decrypting huge db often is not a good idea according to me. What do you think ?
Thanks & Regards,
As per your clarification, I think you are right.
Thanks Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
-
Hello, I have a desktop software developed with VB.NET using Ms Access as backend. I want some security measuremetns vis which the data remains safe and secure - others or employees can't open or view the contents of the data. How can I achieve the same ? Any helpline, guidance is highly appreciative.
Thanks & Regards,
If it's not possible to use SQL Server as others have suggested, you can always encrypt data that's being written into the DB, where the encryption library will be in your application. But it's not fool proof, and it'll mightily slow down all data access.
SG Aham Brahmasmi!