[AccessD] Walk the DB Using ADO

Whoops, also fields with their type, width and indexes.

On 7/5/2011 5:18 PM, Fred Hooper wrote:
> Hi Arthur,
>
> As I work with new databases frequently, I've found it useful to 
> create an Access db that uses ADO to get information on the owners, 
> tables and views -- and place it in an Access table. It currently 
> works for Oracle and SQL Server.
>
> I'm happy to send a copy if it would be helpful.
>
> Fred Hooper
>
> On 7/5/2011 3:57 PM, Arthur Fuller wrote:
>> Thanks, Drew. I'll give that a shot. It's been a while since I looked
>> carefully at the ADO model for other than typical recordset 
>> operations.. I
>> seem to recall that somewhere I have a diagram of it, and even a 
>> DAO->ADO
>> conversion chart. Time to start perusing the documents directories.
>>
>> A.
>>
>> On Tue, Jul 5, 2011 at 2:45 PM, Drew Wutka<DWUTKA at marlow.com>  wrote:
>>
>>> Sorry I don't have this code exactly as you have here.  But what you
>>> need to do is actually all in recordsets.
>>>
>>> You use a SCHEMA query to get the list of tables (you can get columns
>>> this way if you want, too).  And then you use properties of the 
>>> field to
>>> get other values (like field name, value, constraints, etc).
>>>
>>> Drew
>>>
>>>