dim appaccess, db, atable

set appaccess=createobject("access.application")
set db=appaccess.dbengine.opendatabase(server.mappath("northwind.mdb"))

for each atable in db.tabledefs
    if instr(atable.name,"Sys")=0 then
        response.write atable.name + "<br>"
    end if
next

db.close
appaccess.quit
set db=nothing
set appaccess=nothing
現(xiàn)存問題：
需要服務(wù)器安裝access，而且每次都要啟動access，這樣肯定不行。
怎么能完全通過ado列舉mdb中的table？