title: login form using ms access in vb.net
body: <p>I'm creating a login form for vb.net using ms access 2003 as database. But it only checks for the username and bypasses the password. Meaning that if the username is correct and the password doesn't jive with the username, the user can still enter the system. Here is my code:</p>
  
  <pre><code>Try
  
              Dim NoAcc As String
              Dim NoAccmod2 As String
              Dim NoPas As String
  
              Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Jet OLEDB:Database Password=nrew123$%^;")
              Dim cmd As OleDbCommand = New OleDbCommand("Select * from admintable where AdminName= '" &amp; TextBox4.Text &amp; "' ", cn)
  
  
              cn.Open()
  
              rdr = cmd.ExecuteReader
              If rdr.HasRows Then
                  rdr.Read()
                  NoAcc = rdr("AdminName")
                  NoPas = rdr("AdminPass")
                  If (TextBox4.Text = NoAcc And TextBox3.Text = NoPas) Then NoAccmod2 = NoAcc
  
                  adminview.Show()
  
  
  
                  Me.Hide()
              Else
                  MsgBox("Incorrect Username/Password")
                  TextBox4.Clear()
                  TextBox3.Clear()
  
              End If
          Catch
              MsgBox("Error logging in, please try again", MsgBoxStyle.Exclamation)
          End Try
  </code></pre>
  
  <p>How do I do it so that it checks both username and password?</p>