ASP网页代码如下:
<%
dim conn
dim connstr
connstr="DBQ="+server.mappath("../data.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
set rs=server.createobject("adodb.recordset")
rs.open "select * from aaa",conn,3,3
Do Until rs.EOF
Response.Write rs("flxz")&"<br/>"
rs.MoveNext
Loop
response.write rs
rs.close
con.close
set rs=nothing
set con=nothing
%>
运行时提示错误为:
Microsoft OLE DB Provider for ODBC Drivers '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 表达式中 'GetTotal' 函数未定义。
\htxt\xxx.asp, line 8
(视图查询我用了宏创建的视图查询,能有什么解决办法吗?谢谢各位了!)
附件是数据库存文件
点击下载此附件