title: Updating a Microsoft Access 2013 table with data from a pass-through query
body: <p>I am trying, unsuccessfully so far, to update records in a Microsoft Access 2013 table (called tbl_Data) with data from an AS400 table (LIBRARY.TABLE).</p>
  
  <p>As you can see in my Access 2013 pass-through query below, I am trying to join the access table with the AS400 table using the Prefix &amp; Number fields, and from there, update the access table with Name &amp; Address information from the AS400 table.</p>
  
  <p>Here is my latest attempt:</p>
  
  <pre><code> UPDATE 
        tbl_Data
   SET
        tbl_Data.FirstName = a.NINMFR,
        tbl_Data.MiddleName = a.NINMMD,
        tbl_Data.LastName = a.NINAML,
        tbl_Data.BuildingNumber = a.NIBLNR,
        tbl_Data.StreetName = a.NISTNM,
        tbl_Data.AptSuite = a."NIAPT#",
        tbl_Data.Address2 = a.NIADR2,
        tbl_Data.City = a.NICITY,
        tbl_Data.State = a.NISTAT,
        tbl_Data.ZipCode = a.NIZIPC
   INNER JOIN
        LIBRARY.TABLE a
   ON 
        tbl_Data.Prefix = a.NIPRFX,
        tbl_Data.Number = a.NIPLNR;
  </code></pre>
  
  <p>When I run this query, I get an error that says:</p>
  
  <pre><code> OBDC--call failed.
   [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0199 - Keyword INNER not expected. Valid tokens: USE SKIP WAIT WITH WHERE. (#-199)
  </code></pre>
  
  <p>I would really appreciate any assistance, as I'm out of ideas.</p>
  
  <p>Thanks!</p>