<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Untitled Document</title>
</head>
<%
set conn=server.CreateObject("adodb.connection")
' conn.open "driver={microsoft access driver (*.mdb)};dbq=" & server.MapPath("stu.mdb")
conn.provider="microsoft.jet.oledb.4.0"
conn.open server.MapPath("sjk.mdb")
set rec=server.CreateObject("adodb.recordset")
rec.open "select * from table",conn,1,1
%>
<body>
<p> </p>
<table width="358" height="37" border="1" align="center" cellspacing="0">
<tr align="center">
<td>id</td>
<td>user</td>
<td>pass</td>
</tr>
<tr align="center">
<td><%=rec.fields.item("id")%></td>
<td><%=rec("user")%></td>
<td><%=rec.fields.item("pass")%></td>
</tr>
</table>
</body>
</html>
參考答案:对数据库的连接没有关闭。
<%
rec.close
conn.close
%>
加在</body>
之后就可以了。。。。你试一下。
