Is there any method to protect Database

[qiqinuinaifen128]

Is there any method to protect Database. I mean only people who have the password can edit the database or ....

Below is my code

Private Sub Command11_Click()
Data1.Recordset.AddNew
Data1.Recordset.Fields("Code").Value = InputBox("Code")
Data1.Recordset.Update
End Sub

Private Sub Command12_Click()
Data1.Recordset.Delete
End Sub

Private Sub Command13_Click()
Data1.Recordset.MoveLast
Data1.Recordset.Delete
End Sub

Data1.DatabaseName = App.Path & "\menu1.mdb"
Data1.RecordSource = "Table1"
Data1.Refresh

Text9.DataField = "Code"

End Sub

A very Thank for helping and reading my thread

[szlamany]

If you use MS SQL CE (compact edition) you can actually "encrypt" the database with a password...

http://www.microsoft.com/sql/edition...t/default.mspx

[qiqinuinaifen128]

Thank for replying. I am using MS Access 2003 as my database...
is it possible?

[randem]

Not really. The MS Access method is weak. You would have better results encrypting the data in the database (except for the keys of course).

[qiqinuinaifen128]

That mean i hv to give up the idea to enhance my program...
anyway, i am appreaciate for your kindly reply^_^

[RobDog888]

See my Acccess FAQ item on security for other methods:
http://vbforums.com/showthread.php?t=402072

Also, Access supports encrypting the database with a password. If you are using Access 2007 then it uses a newer stronger encryption alogorthium.

[szlamany]

@randem and robdog - what's the ACCESS encryption like? I've only ever used encryption with MS SQL CE - so I know how strong that is.

[RobDog888]

It only satates in Access 2007....
[qupte]A stronger algorithm for encrypting databases in the Office Access 2007 file format that use the database password feature. Encrypting a database scrambles the data in your tables and helps prevent unwanted users from reading your data. [/quote]

Its stronger but there are several new techniques for securing a 2007 .accdb now.

[szlamany]

ok - it sounds like Access 2007 does the same encrypting that MS SQL CE does...

[RobDog888]

I woudnt doubt it. 2003 has the encrypt/decrypt function too but its weaker. 2007 can encrypt older versions of Acccess but it uses the 2003 encryption alogorithum.