[AccessD] Walk the DB Using ADO

Arthur Fuller fuller.artful at gmail.com
Tue Jul 5 17:05:23 CDT 2011

I would most appreciate your Send!


On Tue, Jul 5, 2011 at 5:18 PM, Fred Hooper <fahooper at gmail.com> 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
>>>  --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>

More information about the AccessD mailing list