[AccessD] Walk the DB Using ADO

Would you like me to send my VB6 Add-on to you off list, which lets me
create 'data classes'?  It has code to pull the tables and fields from a
data source using ADO.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, July 05, 2011 2:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Walk the DB Using ADO

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
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.