Sad Der
accessd666 at yahoo.com
Mon Feb 28 03:00:41 CST 2005
Hi group,
i want to list the:
tables;
columns;
propertyname;
values.
It's no problem to retrieve the tables and columns but
when I try to retrieve the propertynames and their
values I get rubish. I've adde my code and some debug
info.
Sub ListTableInfo()
'Create catalog object
Dim Catalog As New ADOX.Catalog
Set Catalog.ActiveConnection =
CurrentProject.Connection
'List tables And columns
Dim Table As ADOX.Table
Dim Column As ADOX.Column
Dim Prop As ADOX.Property
For Each Table In Catalog.Tables
If Left(Table.Name, 4) <> "MSYS" Then
For Each Column In Table.Columns
Debug.Print Table.Name & ", " &
Column.Name
For Each Prop In Column.Properties
Debug.Print "Prop.Attributes: " &
Prop.Attributes
Debug.Print "Prop.Name: " & Prop.Name
Debug.Print "Prop.Type: " & Prop.Type
Debug.Print "Prop.Value: " &
Prop.Value
Next Prop
Next
End If
Next
End Sub
----------------------
DEBUG INFO
Table name: config_Deal_Types_1-5
Column Name: Deal Side
----------------------
config_Deal_Types_1-5, Deal Side
config_Deal_Types_1-5, Deal Side
Prop.Attributes: 1537
Prop.Name: Autoincrement
Prop.Type: 11
Prop.Value: False
----------------------
I excpected:
config_Deal_Types_1-5, Deal Side
Prop.Attributes: ?????
Prop.Name: Field Size
Prop.Type: ?????
Prop.Value: Double
...
Does anybody know how to get what I want?
I'm using ADOX but that's no requirement.
TIA
Sander
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced
search.
http://info.mail.yahoo.com/mail_250
__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250