Question

如何制作网页与Access数据库的连接

Answer 1

//conn.asp
<%
set conn=Server.createobject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.mappath("./mdb/##.mdb")
%>
//index.asp
<!--#include file="./conn.asp"-->
<%
set rs=createobject("adodb.recordset")
sql="select * from users"
rs.open sql,conn,1,3

response.write rs("id")

%>

Answer 2

<%
Settttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt
%>