想无聊问一下现在最常好的 Access 连接方法
想无聊问一下现在最常好又小出问题的 Access 连接方法
是哪个!能提供代码就最好....
我现在用的是这种
<%
MdbName="ly" //你的数据库名
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath( "data/"&MdbName & ".mdb")//数据库路径
'conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath
function dealstr(inputstr,limit)
dim getstr,limited
getstr=trim(inputstr)
getstr=replace(getstr,"<","<")
getstr=replace(getstr,">",">")
getstr=replace(getstr,chr(13),"<br>")
getstr=replace(getstr,"'","''")
limited=cint(limit)
dealstr=left(getstr,limited)
end function
%>