Re: MS Access table and field properties

>
>But how about the comments I put in MS Access for each field? Is there a way
>to retrieve it?
There are some properties of an Access database you can only get using ADOX.
To do this you must import the ADOX type library.
Then you can use code like this




Use ADOX:

var
Column: _Column;
fCatalog : Catalog;
begin

fCatalog := CoCatalog.Create;
fCatalog._Set_ActiveConnection(ADOConnection.ConnectionString);
Column := fCatalog.Tables['tablename'].Columns['columnname'];
strColProp := Column.Properties['Description'].Value;

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages