[AccessD] ADO

Fred Hooper fahooper at trapo.com
Mon Nov 26 20:02:35 CST 2007


Susan,

I'm not sure what you mean by "field properties" and if what I have is what
you want: I wrote a "data dictionary" that I use when I go to a new site.

It takes the table, field, key & index information from a db and places it
in an access table. Currently it works for SQL Server and Oracle by running
a query on the metadata tables/views in the database and saving the results.

If it sounds useful to you please let me know.

Fred Hooper

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, November 26, 2007 2:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ADO

The simple answer is NO.  The query/view doesn't expose field
properties, those are in the table.  Why would you try to use a query
for this?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, November 26, 2007 9:55 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ADO


> But you can use a fixed query in ADO.

=====Can you reference the field properties? That's what I'm doing. 

Susan H. 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list