I have one that is correct for another server, so I used that one as my basis for this one
Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=\\content\main_data\onlineNew.mdb;"
SQL = "INSERT INTO table1
But I get an incorrect path error, for the above and DBQ=\onlineNew.mdb & DBQ=\content\onlineNew.mdb
For simplicity and testing I have my form, ASP script & db named onlineNew.mdb all in one directory on a 3rd party ASP server.
Also do I need to set file permissions on onlineNew.mdb?