title: removing characters from field in MS Access database table
body: <p>Using MS Access 2010.
  I have a field in a table that contains windows path names surrounded by quotes, like this</p>
  
  <pre><code>"C:\My Documents\Photos\img1.jpg"
  "C:\My Documents\Photos\products\gizmo.jpg"
  "C:\My Documents\Photos\img5.jpg"
  </code></pre>
  
  <p>and so on.</p>
  
  <p>I need to get rid of the quotes so the column looks like this:</p>
  
  <pre><code>C:\My Documents\Photos\img1.jpg
  C:\My Documents\Photos\products\gizmo.jpg
  C:\My Documents\Photos\img5.jpg
  </code></pre>
  
  <p>Is there a way to write an update query to do this?
  OR a better way to do it altogether?</p>