Accessing password protected MS ACCESS database

[hall]

Help! I am trying to access a “standalone” Microsoft Access database over the internet through a simple ADO connection. The following code works just fine. Note that the database is stored at db_location which is just some valid location for an Access database and that the database is not password protected.

db_location=”some database location”
Set db = Server.CreateObject("ADODB.Connection")
db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & session("db_location")

Now, when I go into the database and add a password, I get errors when I try to access it over the internet regardless of the many different variations that I try for the connection string. A few are shown below.

db_location=”some database location”
Set db = Server.CreateObject("ADODB.Connection")
db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & session("db_location") & _
";User Id=;password=c5sap"

Error:
Microsoft JET Database Engine error '80004005'
Can't start your application. The workgroup information file is missing or opened exclusively by another user.
(Do I have to have a workgroup info file with users/passwords just because I’ve added a password to the database????)

db_location=”some database location”
db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=” & session(db_location”) & _ “PWD=c5sap"

Error:
Microsoft JET Database Engine error '80004005'
Couldn't find installable ISAM.


Any info would be greatly appreciated.

[Clunietp]

Try this as your connection string:

Provider=Microsoft.Jet.OLEDB.3.51;Data Source=MyDB.mdb;Jet OLEDB:Database Password=password;

[hall]

Thanks very much Clunietp. Worked like a charm.