Hello:
I use ASP Runner to run several applications with an external web hosting company on remote server. Currently, I export the data from my protected MS Access database to unprotected databases in order for the ASP Runner applications to be able to read the data. I am trying to get my ASP Runner applications to read data from protected MS Access databases; however, the connection strings I am using aren't working...
Here is the string I use to connect to unprotected databases (this one is generated by ASP Runner and works):
<%
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("\db\cslportal\portal1.mdb") & ";Jet OLEDB:Database Password="
%>
Here is the string I have been working with trying to connect to the protected database with system database...it isn't working...
<%
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("\db\cslportal\PROD_Database.mdb") & ";Jet OLEDB:System Database=" & server.mappath("\db\cslportal\Workgroup.mdw") & ";User Id=owner;Password=goredick87"
%>
Any help would be much appreciated!!!
