Error calling update()

Results 1 to 2 of 2

Thread: Error calling update()

  1. #1
    Carl Anderson Guest

    Default Error calling update()

    When executing the following code:<BR>Dim objConn<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" &_<BR>"DBQ=" & Server.MapPath("history97")<BR> <BR>objConn.Open()<BR> <BR>Dim strDate<BR> <BR>strDate = Now()<BR> <BR>Dim objRS<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en "History", objConn, , adLockOptimistic, adCmdTable<BR> <BR>objRS.AddNew()<BR>objRS("User") = ""<BR>objRS("Date") = strDate<BR>objRS("BuySell") = "Buy"<BR>objRS("Number") = "8"<BR>objRS("Print") = "Empress"<BR>objRS("Price") = "$1.00"<BR>objRS.Update()<BR><BR>I get the error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. <BR><BR>dbaddpurchase.asp, line 39<BR>which corresponds to the Update() call.<BR>I have tried this on a similar database and have had no problem. Does anyone know what&#039s wrong here?<BR>

  2. #2
    Carl Anderson Guest

    Default RE: Error calling update()

    Oh, a bit more information- I&#039m using an Access &#039 97 database, and my e-mail address is

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts