贴一段asp连接access的代码,希望对入门者有所帮助
<%
set db=server.createobject("adodb.connection")
db.open "DBQ="&server.mappath("access/to_dream.mdb")&";driver={microsoft access driver (*.mdb)}"
set rs=server.createobject("adodb.recordset") '声明一个记录集
dim pagenum
sql="select * from guestbook order by id desc"
rs.open sql,db,3,2
%>
<%
set db=server.createobject("adodb.connection")
db.open "DBQ="&server.mappath("access/to_dream.mdb")&";driver={microsoft access driver (*.mdb)}"
set rs=server.createobject("adodb.recordset") '声明一个记录集
dim pagenum
sql="select * from guestbook order by id desc"
rs.open sql,db,3,2
%>
回复Comments
{commenttime}{commentauthor}
{CommentUrl}
{commentcontent}