Jet Error 80040e14

Results 1 to 2 of 2

Thread: Jet Error 80040e14

  1. #1
    Germaine Carter Guest

    Default Jet Error 80040e14

    Microsoft JET Database Engine error &#039;80040e14&#039; <BR><BR>Syntax error (missing operator) in query expression<BR><BR>The error points to the last line of the code. What could be wrong?<BR><BR>Sub AddToOrder(nOrderID, nProductID, nQuant, strPName)<BR> sqlText = "INSERT INTO itemsOrdered " _<BR> & " (orderID, productID, quantity, pName) values " _ <BR> & " ("&nOrderID&", "&nProductID&", "&nQuant&", "&strPName&")" <BR> Conn.Execute(sqlText)<BR>

  2. #2
    Wild J Guest

    Default RE: Jet Error 80040e14

    Do a response.write of the sqlText variable and see what it is returning for your query and post it here. My guess is that you need to have single apostrophes around strPName. Like this:<BR>&#039;" & strPName & "&#039;<BR><BR>

Posting Permissions

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