Can't open connection to password protected DB (VB6)

[hardbattle]

Help, I cannot open a password protected database connection. When using the following code as the connection string, I get the error msg "Not a valid Password"

strCon = "Provider=Microsoft Jet 4.0 OLE DB Provider" & _
";Data Source=" & sDbPath & _
";Password=workman"

Any suggestions please. (i have a password set on the DB, but no user accounts and no system.mdw file)

[Kevin]

I don't know enough about the Jet engine to give you expert advice, but could it be that you also need to indicate the User. For example, if opening an ADO connection to SQL Server, you need a user id:

"Provider=MSDASQL;Driver={SQL Server};Server=BOB;Uid=sa;Pwd=test;Database=XYZ"

Just a thought...

[charlotte]

You're correct, Kevin. Even using Jet you have to pass the userid in the connection string to open a secured database. The question I would have here is whether the database is secured or just password protected, which isn't the same thing.

[jscher2000]

Try Provider=Microsoft.Jet.OLEDB.4.0 and see if that helps. Illogical, but, the error messages don't always make sense, either.