Please help me,

how can I open a database which is protected by password.

example :

I am using

Set Dbs = OpenDatabase("f:\master.mdb", False)

then I add a password to the mdb for security, the problem after I supply
password to mdb my application cannot run, it say not a valid password.

I don't know how to open it from code.

Thank,s

...Aries...

What kind of Dataaccess do you use?

You could typically make a simple file dsn to the database and then open the
dsn in the Notepad to get the proper syntax.

Thank for your respon.

I am using microsoft access.

I want my database secure by password, so if someone try to open by ms
aceess need a password to open it.

First when I design my application everything going well, and now I did
complete building application, the problem is the operator whose familiar
with ms access is easy to open and browse the database, so I think I need to
put a password on a database.

Now the problem when I am running my application error come up which is say
that not a valid password, that true because until now I dont know how to
control / access a database which have a password from vb6 code.

Thanks ,

Aries

I did try by adding parameter for opendatabase method as you explain but
still have an error.

exactly i try some of this :

set dbs=dbs.opendatabase("f:\master.mdb",false) as parameter
";pwd=mypassword" (i get  error with this command)

than I try define a variable as parameter and set the value of the variable
with my password...... I get error too.

waiting for your next explanation.

Thank's

...Aries...

My problem solve.

This is the message from Deven :

********

 I tried this and it works (on an access database protected by a simple
password, not by using user definitions - no *.mdw)
set db=dbengine.workspaces(0).opendatabase(gdbpathname &
"mydatabase.mdb",true,false,";pwd=mypassword")

********