-
howdy, not sure if this is the proper place to post this question (if you know a good place for ASP forums pls give me URL)
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 Pasword=pass"
Now I get this error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.
What's the problem ?? pls help me with this.....
-
yet another error
Ok I changed the connectionstring to:
Code:
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Datastores\test.mdb; Jet OLEDB DataBase Pasword=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 i
-
Doesn't Pasword have to be spelt Password?
-
..and the posting ought to be in the
ASP, VB Script, Internet and Network Development
forum
http://forums.vb-world.net/forumdisplay.php?forumid=4
You'll probably get more replies! :)