I am building a small tool that will be used to compare 2 database to find differences. I want this
tool to work at least with SQL and Access databases.
For that topic I use a mixture of ADO and ADOX (to have the most detail possible).
My problem for now is that I can retreive the Description field for Access tables and columns but not
This is my code to get the description:
' ----- Retrieve the description from standard ADO since ADOX doesn't
' have it recorded.
Set rsInfo = connSchema.OpenSchema(adSc
Array(Empty, Empty, sTableName, "TABLE"))
If Not (rsInfo.EOF) Then GetTableDesc = rsInfo!Description & ""
How can I retreive that?
Note that this is a cross-post from the VB-Databases topic (http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=vbdatabases&qid=20161951
) because I didn't had good answers!