用asp處理access數(shù)據(jù)庫(kù)
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èn)題:
需要服務(wù)器安裝access,而且每次都要啟動(dòng)access,這樣肯定不行。
怎么能完全通過(guò)ado列舉mdb中的table?
關(guān)鍵詞:access,數(shù)據(jù)庫(kù),asp
閱讀本文后您有什么感想? 已有 人給出評(píng)價(jià)!
- 2
- 2
- 3
- 2
- 5
- 2