database password

[theghost]

I am using dao 3.5 I can create and open my data base with no problems. How can I create and open it with a password? How can i do the same thing using ado. Which is better to use ado, dao or what ever else there is to use?

thanks

Jason

[gson]

'Open Database with password
Dim db as database
set db=opendatabase("C:\Test\db1.mdb",false,false,";pwd=yourpasword")