Dim cnn1 As ADODB.Connection Dim rs As ADODB.RecordsetPublic Sub Command1_Click() If rs!Username = usercontrol1.Username Then If rs!Password = usercontrol1.Password Then usercontrol1.Caption = "match" Exit Sub Else usercontrol1.Caption = "invalid" usercontrol1.Username = "" usercontrol1.Password = "" End If End IfEnd SubPublic Sub Form_Load() Set cnn1 = New ADODB.Connection cnn1.Provider = "Microsoft.Jet.OLEDB.4.0" cnn1.Open "c:\my documents\userdata.mdb" Set rs = New ADODB.Recordset Set rs.ActiveConnection = cnn1 rs.Open "userpass", , , , adCmdTable End Sub
Dim rs As ADODB.RecordsetPublic Sub Command1_Click()
If rs!Username = usercontrol1.Username Then
If rs!Password = usercontrol1.Password Then
usercontrol1.Caption = "match"
Exit Sub
Else
usercontrol1.Caption = "invalid"
usercontrol1.Username = ""
usercontrol1.Password = ""
End If
End IfEnd SubPublic Sub Form_Load()
Set cnn1 = New ADODB.Connection
cnn1.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn1.Open "c:\my documents\userdata.mdb"
Set rs = New ADODB.Recordset
Set rs.ActiveConnection = cnn1
rs.Open "userpass", , , , adCmdTable
End Sub