看一下vb与SQL的问题？

Private Sub Command1_Click()
Adocd1.RecordSource = " SELECt * FROM users WHERe usename ='" + Text1.Text + "' AND PASSWORD = '" + Text2.Text + "'"
Adocd1.Refresh
If Adocd1.Recordset.RecordCount = 0 Then
MsgBox "用户名或密码错误！"
Else
usetype = Adocd1.Recordset.Fields(" usetype ").Value
Unload Me
Form2.Show
End If
End Sub

Private Sub Command2_Click()
End
End Sub
Command1这个控件，实现登录，

Adocd1.RecordSource = " SELECt * FROM users WHERe usename ='" + Text1.Text + "' AND PASSWORD = '" + Text2.Text + "'"
这条语句哪里错了，高手看哈

Adocd1.RecordSource = " SELECt * FROM users WHERe usename ='" & trim( Text1.Text) &"' AND PASSWORD ='"& trim(text2.text) &"'"

这样表面上看好像没什么错误，你这样调试试一下，

把这条数据库语句用msgbox显示出来看看，然后把这条sql语句直接在数据库中查询看看是否能够获取查询的表,即先执行:

msgbox " SELECt * FROM users WHERe usename ='" + Text1.Text + "' AND PASSWORD = '" + Text2.Text + "'"

如果输出的sql语句没有错误，就直接把这条语句放在数据库sql视图中查询看看是否能够获取所要查询的表