[AccessD] Walk the DB Using ADO

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
>>
>>