title: Single quote string causing syntax error (missing operator)
body: <p>I have the following email to add: jan.o'malley@test.com</p>
  <p>The following code is used to update the person info:</p>
  <pre><code>update_info = &quot;update names set &quot; &amp; _
                          &quot;   email= '&quot; &amp; Me.email &amp; &quot;', &quot; &amp; _
                          &quot;   name= '&quot; &amp; Me.name &amp; &quot;', &quot; &amp; _
                          &quot;where id = &quot; &amp; Me.id
  CurrentDb.Execute update_info
  </code></pre>
  <p>When I try to add the above email I get this error:</p>
  <p><a href="https://i.stack.imgur.com/xMqo6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xMqo6.png" alt="enter image description here" /></a></p>
  <p>What should I do to be able to store (and use) this email?</p>