Access, OLEDB and Passwords

[Inhumanoid]

Im trying to connect to an access database with an OLE DB connection string. I know the physical path o the database.

here's an example of the connection string



strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Datastores\test.mdb;"

it works fine.. When I give the database a password an try conecting again i get this error :
Error Type:
Microsoft JET Database Engine (0x80040E4D)
Not a valid password.

Normal I reckon. so I expand the conectinostring to this:


strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Datastores\test.mdb; DataBase Password=pass"


Now I get this error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.

Ok then I changed the connectionstring to:


strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Datastores\test.mdb; Jet OLEDB DataBase Password=pass"


but now it gives me the following error:

Error Type:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

Any Help on this one ?