Open Access containing password with DAO 2

[sisan]

I need your help please

I have an Access MDB containing password, and in my application I open it ReadOnly with DAO(3.6)

I wrote :

Set MyDb = OpenDatabase("MyDb.mdb", , , "Uid=Admin;Pwd=MyPwd;&quot

but VB always told me that my password is invalid. I'm sure I gave a valid password.

Anybody can help me ? Thank you.

 

[phinoppix]

Hi!

Supply a value for all parameters, like...
Set MyDb = OpenDatabase("MyDb.mdb", False, False, "Uid=Admin;Pwd=MyPwd;&quot

 

[sisan]

Thank you, Alphanytz.
I have tried your suggestion, but it raised the message:

Run time error 3151
ODBC--connection to 'C:\MyApp\MyDb.mdb' failed.

Any other suggestion ?

 

[phinoppix]

Sorry for that!

This should work:

Set MyDb = OpenDatabase("C:\MyApp\MyDb.mdb", False, False, "Ms Access;Uid=Admin;Pwd=MyPwd;&quot

MSDN says that to use the last parameter, must supply the database type first w/ semicolon then followed by other params in any order.

Hope this helps!

 

[phinoppix]

Also, if your MDB is Access 2K or 2K2, must use DAO 3.6

 

[sisan]

Yes ! It works!
Thank you, Alphanytz.