connect string for VB to Access with a Password 2

[Vika]

I am having trouble connecting to Access 97 once I set a password in Access. I am connecting from VB6. What does the connect string with the password on the opendb look like?
db.Open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = '" & sDataSource &
"';User Id =; Password = Admin;"

Is this correct??? -- this doesn't work....

 

[edderic]

If you are using a workgroup (system database):

db.provider = "Microsoft.Jet.OLEDB.4.0 "

db.Properties("Jet OLEDB:System database&quot = "c:\sysdb.mdw"

db.Open "Data Source = " & sDataSource & "User Id = Admin;Password = password;"

If your MDB has a database password:

db.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sDataSource & _
"Jet OLEDBatabase Password=MyDbPassword;", _
"admin", ""

Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com