# Re: ADO如何得知Access资料库含那些Table?

Posted by yeong huann on January 22, 1999 at 02:07:24:

In Reply to: ADO如何得知Access资料库含那些Table? posted by 送储鱼 on January 22, 1999 at 01:09:17:

: 请教众高手，用ADO方式开启Access资料库(*.mdb)后，如何能得知该资料库中含那些Table呢?

ADO我是不太清楚,but DAO的方法如下,你可以参考看看
Set Mydb = Workspaces(0).OpenDatabase (Me.Text1.Text)
For Each t In Mydb.TableDefs
If InStr(1, t.Name, "ms", 1) = 1 Then
Else
Combo1.AddItem t.Name
End If
Next

Follow Ups: