private sub cmd_login()
dim username as string
dim userpass as string
dim cn,fs,path
username=trim(text1.text)
userpass=trim(text2.text)
set cn=createobject("adodb.connection")
cn.open "provider=microsoft.jet.oledb.4.0;data source=" & app.path & "\system.mdb"
set fs=createobject("adodb.recordset")
sql="select * from member where username='" & name & "' and userpass='" & userpass & "'"
fs.open sql,cn,1,1
if fs.eof then
msgbox "对不起,登录错误",vbokonly+vbinformation,"系统消息"
else
......
end if