title: data type mismatch in criteria expression in vb.net
body: <p>Please help this would be my last problem in dealing with access database with vb.net if you could help me solve this.
  I'm trying to update ms access data using vb.net and here's my code:</p>
  
  <p>updateuserclass.vb</p>
  
  <pre><code>Public Class UpdateUser
  
      Dim bankai As New Updater
  
  
      Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
          bankai.unum = TextBox1.Text
          bankai.username = TextBox4.Text
          bankai.password = TextBox3.Text
  
  
  
          bankai.updates()
          MsgBox("Successfully updated!")
      End Sub
  </code></pre>
  
  <p>And here's the code in the form which tries to update the data:</p>
  
  <pre><code>Dim bankai As New Updater
  
  
  
  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
      bankai.unum = TextBox1.Text
      bankai.username = TextBox4.Text
      bankai.password = TextBox3.Text
  
  
  
      bankai.updates()
      MsgBox("Successfully updated!")
  
  
  
  End Sub
  </code></pre>
  
  <p>What might be wrong in here?I set it all to string, is the primary key usernum not a string. What do I do, please help thanks.</p>