Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: 80040e14 Syntax error suggestions

    I am using an ASP web page to try and update records in an Access database. However I keep getting this error message:

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

    /data/admin_rates-debug.asp, line 126

    Here is the update statement that is causing the error:

    UPDATE rates Set UnitType='A3', ProductName='Tasteful', SQfeet='843', Bathrooms=1, UnitPrice='200', WHERE UnitID=3

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    The comma before WHERE is incorrect. Are SQfeet and UnitPrice really text fields?

Posting Permissions

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