如何遍历出ACCESS数据库中的所有表的表名

<%
 strConn="DBQ="+server.mappath("tmp_bbsdata.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
 set objConn=server.createobject("Adodb.connection")
 objConn.open strConn
 set rsSchema=objConn.openSchema(20)
 rsSchema.movefirst
 Do Until rsSchema.EOF
 if rsSchema("TABLE_TYPE")="TABLE" then
         response.write rsSchema("TABLE_NAME") & "<br>"   
 end if
 rsSchema.movenext
 Loop
 set objConn=nothing
%>

转载于:https://www.cnblogs.com/38809972/articles/966569.html