Is there any method to protect Database

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

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

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

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).

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

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.

@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.

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.

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

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.