Database Protection

[vdraceil]

Hi,
I developed a game and made a setup..i included my game's database file to it.I just want to prevent users from entering and editing it.how do i do it?

[debasisdas]

What is the database that you are using ?

If using Access what about the Password option.

[Ali Rizwan]

Hi,
I developed a game and made a setup..i included my game's database file to it.I just want to prevent users from entering and editing it.how do i do it?

Hello,
Here is an option.
Save your database into a unfamiliar format.
Means change the format manually by renaming.

And every time game runs the game copys the database file to a temporary folder by renaming and changing the format to .mdb and after saving the information copy again the .mdb file to its original location in unfamiliar format say .lik and delete the old temp database.

Try the other ones told by Debasis.

GOODLUCK
ALI

[vdraceil]

Hello,
Here is an option.
Save your database into a unfamiliar format.
Means change the format manually by renaming.

And every time game runs the game copys the database file to a temporary folder by renaming and changing the format to .mdb and after saving the information copy again the .mdb file to its original location in unfamiliar format say .lik and delete the old temp database.

Try the other ones told by Debasis.

GOODLUCK
ALI

After manually renaming my database,how do i convert or rename it back(to .mdb) from vb6.0 to edit it?is there any command for doing so..

[vdraceil]

What is the database that you are using ?

If using Access what about the Password option.

dim db as databse
dim rs as recordset
 
Private Sub Form_Load
set db = opendatabase(App.path + "/aaa.mdb")
set rs = openrecordset("abc")
End Sub

if i use a password option (in Access) what modifications should i make to the code above??

[debasisdas]

If you are using ADO instead of age old DAO , you only need to change the connection string.

try this sample connection string

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mydb.mdb;" & _ 
           "Jet OLEDB:Database Password=MyDbPassword", _
           "myUsername", "myPassword"
 

[vdraceil]

If you are using ADO instead of age old DAO , you only need to change the connection string.

try this sample connection string

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mydb.mdb;" & _ 
           "Jet OLEDB:Database Password=MyDbPassword", _
           "myUsername", "myPassword"
 

But i hav used DAO in my very large program..i dont think it will be an easy task for me to replace all comands..What do i do for the code i specified??