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
it works fine.. When I give the database a password an try conecting again i get this error :Code:strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Datastores\test.mdb;"
Error Type:
Microsoft JET Database Engine (0x80040E4D)
Not a valid password.
Normal I reckon. so I expand the conectinostring to this:
Now I get this error:Code:strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Datastores\test.mdb; DataBase Password=pass"
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.
Ok then I changed the connectionstring to:
but now it gives me the following error:Code:strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Datastores\test.mdb; Jet OLEDB DataBase Password=pass"
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 ?
