I'm trying to create some code to write a simp[le set of survey responses to an Access data base. I keep getting the error
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/test1/survey_reply.asp, line 10
when I go to run my code. I'm taking the fields from a previous module, but I can't get past my . Here are the ffirst set of lines in my code:
<html>
<head><title>Desktop Technical Services Survey Reply</title><head>
<body bgcolor="#CCCCFF">
<%
Actionvar=Request.QueryString("actionvar")
dim conn
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c://Inetpub//wwwroot//test1//survey.mdb"
SQLstmt = "INSERT INTO Survey (Name,overall_installation,overall_interview,deliv ery,hardware,software,data_move,configs,shares_pri nters, training,problems,followup,improvement,comments)"
SQLstmt = SQLstmt & " VALUES ('" & request.form("Name") & "','" & request.form("overall_installation") & "','" & request.form("overall_interview") & "','" & request.form("delivery") & "','" & request.form("hardware") & "','" & request.form("software") & "','" & request.form("data_move") & "','" & request.form("configs") & "','" & request.form("shares_printers") & "','" & request.form("training") & "','" & request.form("problems") & "','" & request.form("followup") & "','" & request.form("improvement") & "','" & request.form("comments") & "')"
%>
<HR>
SQL statement: <%=SQLstmt%>
<HR>
<%
conn.execute(SQLstmt)
conn.Close
The "conn.open" line is line 10, and I've tried numerous combinations of coding the statement, with no change in the results.
Can anyone give me a clue what I'm doing wrong? Appreciate it...
dBforums
>
0x800A01A8 Object Required Message
11-04-03, 13:46
Linear Mode
