Run-time error '3144' - syntax error for a SQL statement in Microsoft Access 2003

Posted on 2007-07-30
Last Modified: 2010-05-18
Having trouble with the following SQL statement.  Microsoft Access 2003 keeps giving me Run-time error '3144' - syntax error in update statement with the following:  The [Room_Number] field has a data type of text with field size of 50 and [Updated] field is a yes/no.

UPDATE [PROJ_RM] SET [Room_Number] = '1.000.00.L', SET [Updated] = True WHERE [PROJ_RM].[Room_Number] = '1S-2' AND [PROJ_RM].[Updated] = False
Question by:stephenlecomptejr
    LVL 61

    Accepted Solution

    UPDATE [PROJ_RM] SET [Room_Number] = '1.000.00.L',  [Updated] = True WHERE [PROJ_RM].[Room_Number] = '1S-2' AND [PROJ_RM].[Updated] = False

    Only one "SET" keyowrd needed
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    the keyword SET is to be used ONCE:

    UPDATE [PROJ_RM] SET [Room_Number] = '1.000.00.L', [Updated] = True
    WHERE [PROJ_RM].[Room_Number] = '1S-2' AND [PROJ_RM].[Updated] = False

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Query Builder end user tool for SQL Server 1 15
    how to do this MS SQL script? 11 37
    sQL pivot 9 23
    As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now