定义一个记录集变量来接受数据dim rst as new ADODB.Recordsetrst.Open "SELECT lPwd FROM tbLogin WHERE lId=userid"mm=rst("IPwd").value也可以这么写:Cmd.CommandText = "SELECT lPwd FROM tbLogin WHERE lId=userid"set rst=cmd.executemm=rst("IPwd").value
使用记录集,然后通过记录集访问