透過ADO取得Access資料庫的所有資料表名稱

摘要:透過ADO取得Access資料庫的所有資料表名稱

感謝小舖中的老頑童大大提供的方法

Dim DbFile, DBPath, Conn, Rs
DbFile="Db.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath(DbFile)
Conn.open "Driver={Microsoft Access Driver (*.mdb)}; Dbq=" & DBPath
Const adSchemaTables = 20
Set Rs = Conn.OpenSchema(adSchemaTables,array(empty,empty,empty,"Table"))
If Not(rs.BOF And rs.EOF) Then
rs.MoveFirst
For y = 1 to rs.RecordCount
    Response.Write Rs("Table_Name") & ""
    Rs.MoveNext
Next
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
 

 


以下是簽名:


Microsoft MVP
Visual Studio and Development Technologies
(2005~2019/6) 
topcat
Blog:http://www.dotblogs.com.tw/topcat