Access password & ASP

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.....

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! :)