Start New Discussion within our Software Development Community

As title show. I still not able to connect my ms.access login database . Please help me ~

        Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\leong\Documents\Visual Studio 2010\Projects\WindowsApplication4\WindowsApplication4\coursework.accdb")
        ' Dim cmd As OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username ='" & Usernametxt.Text & "' AND Password ='" & Passwordtxt.Text & "'", con)
        Dim cmd As New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username = 'admin' AND Password = 'admin'", con)

        Dim sdr As OleDb.OleDbDataReader

        sdr = cmd.ExecuteReader()
        ' If the record can be queried, Pass verification and open another form.  
        If (sdr.Read() = True) Then
            MessageBox.Show("The user is valid!")

            MessageBox.Show("The user is invalid!")
        End If

This article has been dead for over six months. Start a new discussion instead.