title: Why Access don't update this?
body: <p>I have a table called <code>Contacts</code> with one field called <code>Contacts.Title</code>.</p>
  
  <p>In MS-Access, If I do a query like this:</p>
  
  <pre><code>SELECT *
  FROM Contacts
  WHERE (((Contacts.Title) Like "%Boss%");
  </code></pre>
  
  <p>It works and found 70 rows. But if I try to do the next update, it doesn't find any row:</p>
  
  <pre><code>UPDATE Contacts
  SET Contacts.Title = "Boss"
  WHERE (((Contacts.Title) Like "%Boss%");
  </code></pre>
  
  <p>If I do the same query in the SQL Server (the table in Access is vinculated from a SQL Server) it works, changing the 70 rows. This question is not how to do that (because I just did in SQL Server without problems), is about why MS Access didn't find any row in the update? </p>
  
  <p>I did something wrong? Or I'm  ignoring something?</p>