'创建Connectiong对象
set conn=server.createobject("adodb.connetction")
'创建OLE DB连接字符串
CS="Provider=Microsoft.jet.OLEDB.4.0;Data Source="
conn.ConnectionString=CS & Server.MapPath("yourdb.mdb")
'打开连接
conn.open
________________________________________________________
另外,如果用Python里面的win32com包做这个事情,这样:
import win32com.client
connectionstring="Provider=Microsoft.jet.OLEDB.4.0;Data Source="
conn=win32com.client.dispatch("adodb.connection")
conn.open connectionstring
(adoRS, success) = adoConn.Execute('SELECT * FROM Clients')
adoRS.MoveFirst()
adoRS.Fields("CompanyName").Value