<div>
<div class="content wysiwyg-content">
I need to update an MS Access 2003 database &nbsp;table based on a condition<br />
I tried I tried<br />
update tblA &nbsp; &nbsp;set Fld1 = B.Fld1 &nbsp; from tblA A inner &nbsp; join tblB B &nbsp; &nbsp; on A.Fld2 = B.Fld2 &nbsp; &nbsp;where B.Fld3 not in ( '000' , '001')<br />
<br />
Also I tried options from following (It works for oracle. But not for Access)<br />
<br />
&nbsp; <a href="https://www.experts-exchange.com/questions/29083921/update-Oracle-11g-table-tblA-based-on-a-condiion-on-tblA-and-tbl2.html" rel="ugc">https://www.experts-exchange.com/questions/29083921/update-Oracle-11g-table-tblA-based-on-a-condiion-on-tblA-and-tbl2.html</a>
</div>
</div>


I need to update an MS Access 2003 database  table based on a condition
I tried I tried
update tblA    set Fld1 = B.Fld1   from tblA A inner   join tblB B     on A.Fld2 = B.Fld2    where B.Fld3 not in ( '000' , '001')

Also I tried options from following (It works for oracle. But not for Access)

  https://www.experts-exchange.com/questions/29083921/update-Oracle-11g-table-tblA-based-on-a-condiion-on-tblA-and-tbl2.html

MS Access update a table with condition joining to another table

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.