<div>
Sorry for the late response. &nbsp;This works. &nbsp;May thanks.
</div>


Sorry for the late response.  This works.  May thanks.

<div>
<div class="content wysiwyg-content">
I have been having problems with what I thought was an &nbsp;easy update query, using the following query, and the error prompt simply says it cannot update database. &nbsp;I have tested this code many times trying to run an update query to replace existing staging table values with mapped values. &nbsp;Appreciate it if anyone can help.<br />
<br />
The SQL Code is as follows:<br />
<br />
UPDATE stgOutcomeDataUpload <br />
SET stgOutcomeDataUpload.SPass<wbr />ABC = (SELECT &nbsp;lkpStage4FieldMappings.Fie<wbr />ldValue<br />
FROM &nbsp;lkpStage4FieldMappings, stgOutcomeDataUpload<br />
WHERE stgOutcomeDataUpload.SPass<wbr />ABC = lkpStage4FieldMappings.Fie<wbr />ldString AND (((lkpStage4FieldMappings.<wbr />FieldName)<wbr />=&quot;SPassABC<wbr />&quot;)));<br />
<br />
<br />
thanks
</div>
</div>


I have been having problems with what I thought was an  easy update query, using the following query, and the error prompt simply says it cannot update database.  I have tested this code many times trying to run an update query to replace existing staging table values with mapped values.  Appreciate it if anyone can help.

The SQL Code is as follows:

UPDATE stgOutcomeDataUpload 
SET stgOutcomeDataUpload.SPassABC = (SELECT  lkpStage4FieldMappings.FieldValue
FROM  lkpStage4FieldMappings, stgOutcomeDataUpload
WHERE stgOutcomeDataUpload.SPassABC = lkpStage4FieldMappings.FieldString AND (((lkpStage4FieldMappings.FieldName)="SPassABC")));


thanks

Access Database-Update Query Error - Cannot Update

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.