In the post below, the guy listed RowSource and RowSourceType as properties of an Access column.
http://www.experts-exchange.com/Data..._10310950.html
But, when I run the same loop over column's properties, I only get 15 properties. (and rowsource and rowsourcetype aren't in that collection).
I'm wondering if its my connection string or driver? I'm using ADOX 2.7
that returnsCode:'recordset and connection variables Dim Cnxn As ADODB.Connection ' Open a connection Cnxn = New ADODB.Connection() Dim strCnxn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbfile & ";" Cnxn.Open(strCnxn) Dim cat As New ADOX.Catalog() 'Create new access database cat.ActiveConnection = Cnxn Dim tbl As ADOX.Table tbl = cat.Tables(tablename) Dim col As ADOX.Column col = tbl.Columns(fieldname) Dim i As Integer For i = 0 To col.Properties.Count - 1 Debug.WriteLine(col.Properties(i).Name & " = " & CStr(col.Properties(i).Value)) Next
thanks,Code:Autoincrement = False Default = Description = Unit of measure for the area. Nullable = False Fixed Length = False Seed = 1 Increment = 1 Jet OLEDB:Column Validation Text = Jet OLEDB:Column Validation Rule = Jet OLEDB:IISAM Not Last Column = False Jet OLEDB:AutoGenerate = False Jet OLEDB:One BLOB per Page = False Jet OLEDB:Compressed UNICODE Strings = True Jet OLEDB:Allow Zero Length = True Jet OLEDB:Hyperlink = False




Reply With Quote