Two difficult ADO questions
-
1. I have one Access .mdb file. How to read the names of the tables in it, using ADO 2. In the same database, how to read the description field of each column, using ADO again Any answer will be helpfull. Thanx in advance!!!
ADO object model doesn't permit this. DAO has the objects and methods you need:
Database object
TableDefs collection
TableDef
Fields collectionHope this helps, Bill
-
1. I have one Access .mdb file. How to read the names of the tables in it, using ADO 2. In the same database, how to read the description field of each column, using ADO again Any answer will be helpfull. Thanx in advance!!!
1. This can be done using the OpenSchema method of ADODB.Connection. Set rs = myADOConnection.OpenSchema(adSchemaTables) While Not rs.EOF debug.print rs!TABLE_NAME rs.MoveNext Wend 2. Don't know, but check out the OpenSchema method. Øyvind