oh wait it helps if I give you some code. I'm pointing to this sub before I do any other login stuff I had previously and I get the previous posts error message
Code:Sub test() Dim command As OleDbCommand Dim connection As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Shawn\Desktop\HPCR.accdb") Dim SQL As String = "SELECT username FROM accounts WHERE username = @username" command.Parameters.AddWithValue("@username", login.usernameTextbox.Text) command = New OleDbCommand(SQL, connection) If connection.State = ConnectionState.Closed Then connection.Open() End If Dim reader As OleDbDataReader = command.ExecuteReader() If reader.Read() Then user.username = Convert.ToString(reader("username")) MessageBox.Show(user.username) End If End Sub




Reply With Quote
