Kinda get you. I changed the local connection string to
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_eftc_STRING
MM_eftc_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\database\chef.mdb"%> %>
But it tells me
Data Source name not found and no default drive specified?
Also, given that logic, my file index2.asp should work once it's online if that previous code was good for the uploaded connection. But it doesnt.
Is it possible to pay for a support ticket to get to the bottom of this. Appreciate its not a WA issue but a DW one...?