ASP ACCESS 数据库

来源：百度知道 编辑：UC知道 时间：2024/06/22 02:08:44
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim conn,connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("acces.mdb")
conn.open connstr
dim rs,pass_fl,pass_ac,sql
set rs=Server.CreateObject("Adodb.Recordset")
rs.open "select pass from password",conn,1,1
pass_ac=rs("password")
pass_fl=Request("pwd")
if (pass_ac=pass_fl) then
response.Write("&mge=a")
else
response.Write("&mge=b")
end if
%>
这也有错???
rs.open "select pass from password",conn,1,1 我试了无数次就是不知道我错在哪...
错误代码 from子句语法错误 80040e14
password--->Access数据库保留字
rs.open "select pass from password",conn,1,1
修改:
rs.open "select pass from [password]",conn,1,1
为什么要这样改才对呢?

password--->Access数据库保留字
rs.open "select pass from password",conn,1,1
修改:
rs.open "select pass from [password]",conn,1,1

connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("acces.mdb")
改成
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("access.mdb")

"select pass from password"中应该有条件吧，返回的记录集应该不是一个值吧。

rs.open "select pass from password",conn,1,1
改成
rs.open "select pass from [password]",conn,1,1
或
rs.open "select [pass] from [password]",conn,1,1
试试
因为password是关键词，要用[]括起来，以示其别，表明这里是字段名称，
比如你有一个字段叫from,而from是关键词你写成
rs.open "select * from from",conn,1,1 就会出错，
改成
rs.open "select * from [from]",conn,1,1
就可行

sql="select * from password where pass='"&trim(request("pwd"))&"