title: Is there a difference in syntax between OLE and Access
body: <p>I ran this morning in a problem I can't find answer anywhere, so now I'm just asking to people who might have more knowledge than me on the subject ;). So here's the problem, when I'm executing a certain query in MS Access I got the rows I am expecting to receive, no problem there. However, when I run the exact same command (copy-paste) in an OleDbCommand object, it doesn't return anything. My datatable is empty. I'll copy the query so you might spot a difference in the syntax I might not be aware of:</p>
  
  <pre><code>odbCommand = New OleDbCommand( _
      "SELECT IDTemps, NomEmploye, HreAllouees, HreReelles, TauxHoraire, " &amp; _
      " Description, NoProjet_Short, NoJob, Type FROM TableA " &amp; _
      " WHERE NoProjet_Short = '13015' " &amp; _
      " AND Type = 'DessinE' ", odbConnection)
  
      dbAdapter = New OleDbDataAdapter(odbCommand)
      odbConnection.Open()
      dbAdapter.Fill(dtTable)
  </code></pre>
  
  <p>Note: this is the core of the code, did not paste the error management (since I have no error, my DataTable is just empty, and should not be).</p>
  
  <p>Thanks
  Simon</p>