MS Access Database query file path criteria in c#

Question

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?

Thanks

Answer 1

You can try:

@"K:\PDFFiles\myPDF.pdf"

or

"K:\\PDFFiles\\myPDF.pdf"

Does your select statement quote the path, something like this (note the single quotes around the parameter):

string sql = string.Format("select * from MyTable where MyPathField = '{0}'", "K:\\PDFFiles\\myPDF.pdf");