View Single Post
  #3 (permalink)  
Old June 9th, 2004, 11:56 PM
askaggs askaggs is offline
Registered User
 
Join Date: Jun 2004
Location: Savannah, TN, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, I'm getting there...  I missed a parenthesis.  I needed one right before the last double quotes.  Now...on to the next error.  :)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Line 14 is the same code that was line 9 (I added your suggested debugging code above and just commented it out) with the addition of the parenthesis.

set oRs = oConn.Execute("INSERT INTO tblLoginInfo(usrnm,psswrd,rlnm,eml,qstn,answr) VALUES('" & request.Form("usrnm") & "','" & request.Form("psswrd") & "','" & request.Form("rlnm") & "','" & request.Form("eml") & "','" & request.Form("qstn") & "','" & request.Form("answr") & "')")


Thanks already for your help.

Andrew Skaggs
Reply With Quote