Password with DataControl [vb6]

Using a data control, I set the database name property to the location, but how do I tell the control what the database password is?

Using a data control, I set the database name property to the location, but how do I tell the control what the database password is?

In the connection string property.

Using a data control, I set the database name property to the location, but how do I tell the control what the database password is?

In the connection string property.

Thanks,

So do I just add pwd=pass to the connection string, and keep the database location in the databaselocation property?

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

sorry for the :D i didn't realise it at that time... it means : D

try this

Provider=Microsoft.Jet.OLEDB.4.0; Data Source = db.mdb; Jet OLEDB:Database Password=yourpass

Thanks a lot, I will try it when I get home.