title: MS Access Database query file path criteria in c#
body: <p>I have an MS Access database that has Full paths to files in a table. We are moving all the file to a different location. I need to update the database. I'm using C# to do this. When I search for the file path stored in access it searches for 'K:\PDFFiles\myPDF.pdf' instead of 'K:\PDFFiles\myPDF.pdf' and does not find a match. So, my question is how do I query the access database for the correct file name instead of the escaped file name?</p>
  
  <p>Thanks</p>