Protection of .mdb files

How to protect my microsoft database file and open it from my visaul basic project.

Please: not with passowrd protection, because there are a lot of easy to use haker programs to know my complicated password

Who is Participating?
pierrecampeConnect With a Mentor Commented:
pasword protection on access db's is easely bypassed
but i yet have to encounter someone who could get past user-lever security on a access db
i suppose you do not have msaccess so look here:
Well, the other way is to use the VB program to encrypt and decrypt every piece of data going through the DB.

After you set up your fields in the table, have each field call an encrypt routine before being Inserted or Updated such as this:

strSQL = "Update tblXXX Set field1 = " & EncryptData(txtField1.Text) & ", field2 = " & EncryptData(txtField2.Text)

And decrypt when retrieved:
strSQL = "Select field1, field2 from tblXXX"
txtField1.Text = DecryptData(rstYYY.Field("field1").Value)
txtField2.Text = DecryptData(rstYYY.Field("field2").Value)

Private function EncryptData(DataToEncrypt as String) as String
' encryption routine of your choice
End function

Private function DecryptData(DataToDecrypt as String) as String
' decryption routine of your choice
End function

elzohryAuthor Commented:
is there any other way ,
The Ecryption will make my Database So slow .
I used lot of memo Fields
Richie_SimonettiIT OperationsCommented:
So, migrate to SQL Server/Oracle/informix or other one.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.