VB Code:
  1. Private Sub Command1_Click()
  2.     Dim db As Database
  3.     Dim tDef As TableDef
  4.     Dim i As Integer
  5.     Set db = OpenDatabase("C:\test.mdb")
  6.     For Each tDef In db.TableDefs
  7.         Debug.Print "Table : " & vbTab & tDef.Name
  8.         For i = 0 To tDef.Fields.Count - 1
  9.             Debug.Print "Field : " & vbTab & vbTab & tDef.Fields(i).Name
  10.         Next i
  11.     Next tDef
  12. End Sub