Microsoft JET Database Engine 错误 '80040e10' 帮帮忙呀!谢谢拉!!!

来源：百度知道 编辑：UC知道 时间：2024/05/30 11:21:27
<html><body>
<!--#include file="adovbs.inc" -->
<%
dim asm,ash,adj,objconn
asm=request("sm")
ash=request("sh")
adj=request("dj")
set objconn=server.createobject("ADODB.connection")
objconn.connectionstring="provider=microsoft.jet.oledb.4.0;"& "Data source="& server.mappath("STORE.MDB")
objconn.open
dim strSQL
strSQL="insert into 产品类型(书名,书号,定价) values(asm,ash,adj)"
objconn.Execute(strSQL)
%>
您新增的内容：<%=asm%>,<%=ash%>,<%=adj%>
<a href="gl.asp">返回管理</a>
</body></html>
<xz.asp>

1)asm=request("sm") 要用request.QueryString("sm") for get 或者request.form("sm") for post.
2)还没有打开表,
set objconn=server.createobject("ADODB.connection")
objconn.connectionstring="provider=microsoft.jet.oledb.4.0;"& "Data source="& server.mappath("STORE.MDB")
SET rs = server.CreateObject("ADODB.RecordSet")
rs.Open "Select * From 产品类型", bjconn