[dba-Tech] How to get programmatic access to lookuppropertiesinadp tables?

Here is the info I should have found before starting this thread:

http://www.winnetmag.com/SQLServer/Articles/ArticleID/22727/pg/2/2.html

Shamil

----- Original Message ----- 
From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
To: "Discussion of Hardware and Software issues"
<dba-tech at databaseadvisors.com>
Sent: Friday, October 29, 2004 4:47 AM
Subject: Re: [dba-Tech] How to get programmatic access to
lookuppropertiesinadp tables?


> Yes, John, I know that they don't have any mdb tables etc.
>
> I think this was my bad day I asked this question - the answer is
obvious -
> they keep these properties's values in extended properties of MS SQL
tables'
> columns.
>
> Easy :)
>
> But still to verify that it's true by accessing these properties' values
> using SQLDMO....
>
> Shamil
>
> ----- Original Message ----- 
> From: "John W. Colby" <jwcolby at colbyconsulting.com>
> To: "'Discussion of Hardware and Software issues'"
> <dba-tech at databaseadvisors.com>
> Sent: Friday, October 29, 2004 4:21 AM
> Subject: RE: [dba-Tech] How to get programmatic access to lookup
> propertiesinadp tables?
>
>
> > That's because ADPs don't have any MDB tables or access to any such
> things.
> > No linked tables of any kind.  Since DAO only works with the MDB tables,
> it
> > doesn't exist in an adp.
> >
> > John W. Colby
> > www.ColbyConsulting.com
> >
> > Contribute your unused CPU cycles to a good cause:
> > http://folding.stanford.edu/
> >
> > -----Original Message-----
> > From: dba-tech-bounces at databaseadvisors.com
> > [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Shamil
> > Salakhetdinov
> > Sent: Thursday, October 28, 2004 3:53 PM
> > To: DBA-Tech
> > Subject: [dba-Tech] How to get programmatic access to lookup properties
> > inadp tables?
> > Importance: High
> >
> >
> > 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
> >
> >
> >
> > _______________________________________________
> > 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