title: MS Access update query and inner join with string parameter
body: <p>Please help me solve this problem in MS Access. I want to update my <code>user table</code> using the <code>statusid</code> that I will get in <code>userstatus table</code>.</p>
  
  <p>This query properly work in MySQL. Why in MS Access not. Inner join with a parameter of string doesn't work.</p>
  
  <pre><code>UPDATE tbl_users AS us
    INNER JOIN tbl_userstatus AS ust ON ust.status = "Offline"  
  SET us.statusid =  ust.statusid 
  WHERE us.username = "francis";
  </code></pre>