[dba-Tech] How to get programmatic access to lookup properties inadp tables?

Francisco,

The answer is ::fn_listextendedproperty.
It can be used in ado recordset opened via VBA code.
BOL has good descripton of this UDF.

Shamil

----- Original Message ----- 
From: "Francisco Tapia" <fhtapia at gmail.com>
To: "Discussion of Hardware and Software issues"
<dba-tech at databaseadvisors.com>
Sent: Monday, November 01, 2004 10:17 PM
Subject: Re: [dba-Tech] How to get programmatic access to lookup properties
inadp tables?


> Shamil,
>   I don't believe this property is available.  Your tables are all Sql
> in an ADP thus you'd need to run a sproc/view that will select the
> column property.  So in a word it's not accessible via code in that
> way, you MUST go through the sql server engine to gain any information
> reguarding the tables.
>
>
> On Fri, 29 Oct 2004 08:42:31 +0200, Gustav Brock <gustav at cactus.dk> wrote:
> > Hi Shamil
> >
> > Why not address this to the AccessD list?
> > Seems right "on topic" to me ...
> >
> > /gustav
> >
> > > Date: 2004-10-28 21:53
> >
> >
> >
> > > Here is a tough one or I'm missing something obvious?
> >
> > > I .mdb I can write for a table's field, which has combo lookup
defines:
> >
> > > Dim dbs As DAO.Database
> > > Dim tdf As DAO.TableDef
> > > Dim prp As DAO.Property
> > >     Set dbs = CurrentDb
> > >     Set tdf = dbs.TableDefs("tblTest")
> > >     Set prp = tdf.Fields("F2").Properties("RowSource")
> > >     Debug.Print prp.Value
> >
> > > I can't find how can I do similar thing in .adp?
> >
> > > TIA for any help,
> > > Shamil
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
>
>
> -- 
> -Francisco
> <a href="http://pcthis.blogspot.com">Pc This! pc news with out the
jargon</a>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com