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

yes, but it goes throught Sql engine, and if you don't give your users
enough rights they wouldn't be able to read it (iirc).


On Mon, 1 Nov 2004 22:49:25 +0300, Shamil Salakhetdinov
<shamil at users.mns.ru> wrote:
> 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
> 
> _______________________________________________
> 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>