Question

这是啥原因啊，asp中？ ADODB.Recordset (0x800A0CC1) 在对应所需名称或序数的集合中，未找到项目。

access里的字段没对应错
代码如下
<%
if request.form("user")="" or request.form("ps")="" then
response.redirect "online.asp"
end if
dim user,ps
user= trim(request.form("user"))
ps = trim(request.form("ps"))
Dim conn,strConn
Set conn=Server.CreateObject("ADODB.Connection")
strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
conn.Open strConn
Dim rs,strSql
Set rs=Server.CreateObject("ADODB.Recordset")
strSql ="Select * From userinfo where name='" & user & "'and pwd='" & ps & "'"
Set rs=conn.Execute(strSql)
if rs.eof then
response.redirect "online.asp"
else
response.write "登录成功"
end if
end if
%>

Answer 1

strSql ="Select * From userinfo where name='" & user & "'and pwd='" & ps & "'"
问题出在了name='" & user & "'and 这里，and 前面没有空格
你改成
strSql ="Select * From userinfo where name='" & user & "' and pwd='" & ps & "'"
应该就没有问题了

Answer 2

如果确定表名，字段名都没错的话，将
strSql ="Select * From userinfo where name='" & user & "'and pwd='" & ps & "'"
改为
strSql ="Select * From userinfo where [name]='" & user & "' and pwd='" & ps & "'"

Answer 3

字段名错了，仔细检查一下，还有想楼上说的name是关键字用[]括起来