Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=f:\aa.mdb"
db.Open
rs.CursorLocation = adUseClient
rs.Open "select * from usertable where username=张三疯", db
if rs.RecordCount>0 then
msgbox "此用户已经存在
else
msgbox "没有存在"
end if