title: Update a single table based on multiple tables - appears to works MySql not ACCESS 2003
body: <p>Mysql Version Works</p>
  
  <pre><code>UPDATE results SET rCARRIER = (
      SELECT cellCarrierName
      FROM tblImportedTempTable, user, cellCarrier
      WHERE
          userEmployeeNumber = tblImportedTempTable.EMPLOYEENUMBER
          AND userId = results.rUserId
          AND results.rPHONENUMBER = tblImportedTempTable.PHONENUMBER
          AND CARRIER = cellCarrierId )
  </code></pre>
  
  <p>I have written this sql that works fine in MySql(above) and fails in access 2003(below) any suggestions? Is one or both of the 2 nonstandard sql? Does Access hav an admin problem?</p>
  
  <p>Sorry the field and table names are diferent this is the ACCESS version.</p>
  
  <p>Access version</p>
  
  <pre><code>UPDATE tblWorkerPhoneNumber SET tblWorkerPhoneNumber.PhoneCarrier = (
      SELECT PhoneCarrierType.CarrierName
      FROM tblImportedPhoneCarrier, tblWorkerMaster, PhoneCarrierType
      WHERE
          tblWorkerMaster.EmployeeNumber = tblImportedPhoneCarrier.Emp
          AND tblWorkerMaster.WorkerID = tblWorkerPhoneNumber.WorkerID
          AND tblWorkerPhoneNumber.PhoneNumber = tblImportedPhoneCarrier.Cell
          AND tblImportedPhoneCarrier.CarrierCode = PhoneCarrierType.CarrierID )
  </code></pre>
  
  <p>Error Message
  Operation must use and updateable query</p>
  
  <p>Thanks</p>