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


Code:
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:

Code:
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:

Code:
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 ?