Dim adocon As ADODB.Connection dim i as integer,j as integer Set adocon = New ADODB.Connection adocon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\newdata.mdb;" & "Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password=" Set cat = New ADOX.Catalog Set cat.ActiveConnection = adocon For i = 0 To cat.Tables.Count MsgBox cat.Tables(i).Name '取出表名 For j = 0 To cat.Tables(i).Columns.Count MsgBox cat.Tables(i).Columns(j).Name '取出列名 For Each p In col3.Properties MsgBox p.Type & p.Name & p.Attributes '取出列的属性 Next Next j Next i Set cat = Nothing adocon.Close Set adocon = Nothing
dim i as integer,j as integer
Set adocon = New ADODB.Connection
adocon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\newdata.mdb;" & "Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password="
Set cat = New ADOX.Catalog
Set cat.ActiveConnection = adocon
For i = 0 To cat.Tables.Count
MsgBox cat.Tables(i).Name '取出表名
For j = 0 To cat.Tables(i).Columns.Count
MsgBox cat.Tables(i).Columns(j).Name '取出列名
For Each p In col3.Properties
MsgBox p.Type & p.Name & p.Attributes '取出列的属性
Next
Next j
Next i
Set cat = Nothing
adocon.Close
Set adocon = Nothing