Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("xxx.mdb")
SQL="Select * from table where id<>1 order by id desc"
Set RS = Server.CreateObject("ADODB.RecordSet")
RS.open SQL , Conn , 3
用conn连接数据库,用sql存储语句,用rs对象得到结果