asp连接access数据库的方法

<%
 db_name="xxxx.mdb"                 
 connstr="DBQ="+server.MapPath(db_name)+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)}"
set conn=server.CreateObject("ADODB.Connection")
conn.open connstr

或者

db_name="xxxx.mdb"
set conn=server.createobject("ADODB.CONNECTION")
connst="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db_name)
conn.open connst
%>