title: Return ID on MSAccess and has a datatype of AutoNumber(java)
body: <p>I want to get the row of a record with a specific ID that has a type of 'AutoNumber.</p>
  
  <p>I do it this way:</p>
  
  <pre><code>String sql = "select * from test where ID = '"+1+"'";
  rs = st.executeQuery(sql);
  </code></pre>
  
  <p>It gives me this error , </p>
  
  <pre><code>java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
  </code></pre>
  
  <p>How should i do it correctly ?</p>