Using ADO Connection
Using ADO Connection is more faster than using DAO.
Here is a sample of password checking using ADO for your reference.
Private Sub cmdOK_Click()
CurUser = UCase(Me.txtUserName)
rs.Open "Select * from User_SecurityInfo where UserID= '" & CurUser & "'", db...