How can I set the RowSource property of MDB?
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
Code:
'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
that returns
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
thanks,