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

Posted on 2007-07-30
Medium Priority
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

mbizup earned 2000 total points
ID: 19593944
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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 19593945
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

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

627 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