when i try to add a new entry i get this error
what have i done wrong
here is the code: i have checked form & all form fields are named
correctly !!!
<%
Dim myConn 'Database Connection Variable
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "tonya"
Dim myRS
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "journal", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("date") = Request.Form("date")
myRS("title") = Request.Form("title")
myRS("text") = Request.Form("text")
myRS("pic") = Request.Form("pic")
myRS.Update
myRS.Close
Set myRS = Nothing
myConn.Close
Set myConn = Nothing
%>
<p>Record added.<br>