Hi all, found a solution to the problem, and it is a known bugbear with GoDaddy but this asp file resolves it:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_access_MySite_STRING
MM_access_MySite_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:hosting\MyAccount\access_db\MySite.mdb;Us er Id=;Password="
%>
Andy, i'm still interested so I have sent you a PM, hope to hear from you soon.