data member not found

[meetmaruthi]

Hai i am searching a database (in ms access ) to validate user info.it has two fields username and password.
here is the coding and i get compile error:Method or data member not found.please help
Private Sub Command1_Click()
Set ch = ADODB.Recordset
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\sruniep\ssp\db\user.mdb;Mode=ReadWrite|Shar e Deny None;Persist Security Info=False"
ssql = "SELECT * FROM log WHERE Username =" & Text1.Text & " AND Password = " & Text2.Text & " "
ch.open ssql, Conn, adOpenDynamic, adLockReadOnly

If Not ch.EOF Then
main.Show
Unload Me ' Unload login form
Else
MsgBox " Invalid Login!! Username and Password did not match", vbCritical
i = i + 1 'Another chance passes by
End If
If i = 3 Then 'Not a member
Unload Me
MsgBox "Aborting Application :Restart Application with proper Authentication", vbCritical
Unload main
End If
ch.Close 'Close the recordset
Set ch = Nothing
End Sub


when i run the program it highlights the folowing line in yellow
Set ch = ADODB.Recordset
and reports Comple Error:Method or Data Member not found

i am accessing login info stored in an ms access database "database is user.mdb and table is log"
please guys help me in this matter
mai me at<[e-mail]>