title: Clear with query in database access 97 mdb c #
body: <p>I created a button with link code to the 97 access database and a delete query, but when I run the code, nothing is deleted in the database</p>
  <pre><code> private void button3_Click(object sender, EventArgs e)
      {
          OleDbConnection connect = new OleDbConnection();
          connect.ConnectionString = @&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot;+ textBox1.Text;            
          connect.Open();
          OleDbCommand cmd = new OleDbCommand(&quot;DELETE FROM cartellini WHERE id_car LIKE '??2021????'&quot;, connect);
          cmd.ExecuteNonQuery();
          MessageBox.Show(&quot;Data Deleted&quot;, &quot;Deleted&quot;, MessageBoxButtons.OK, MessageBoxIcon.Information);
          connect.Close();            
      }
  </code></pre>
  <p>how can i solve the problem?</p>
  <p><a href="https://i.stack.imgur.com/nRQgt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nRQgt.png" alt="enter image description here" /></a></p>