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

    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
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    The comma before WHERE is incorrect. Are SQfeet and UnitPrice really text fields?
    Paul

Posting Permissions

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