Accessing Password Protected MS ACCESS Database

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.

Hi hall,
Try this

Connection.Provider = "Microsoft.Jet.OLEDB.4.0"
Connection.Properties("Data Source") = database path
Connection.Properties("Jet OLEDB:Database Password") = dbpassword

Connection.Open
Hope this solves your problem.

Thanks very much msdnexpert!