By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,287 Members | 1,509 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,287 IT Pros & Developers. It's quick & easy.

About OpenSchema(27) and rstSchema("FK_COLUMN_NAME")

P: n/a
Hi all there,

I have developed an ASP script that is able to read the structure of an
Ms Access database ( via object objConn.OpenSchema(27) ) and to
identify the foreign Keys columns and tables (via
rstSchema("FK_COLUMN_NAME") and rstSchema("FK_TABLE_NAME")).

I wonder whether there is a way to read the displayed field name of the
foreign key too.

So to say, for example, in Access, I have a table books. A field of
this table is a "lookup table" type that looks into the foreign Key
FKAuthor of Authors table and displays the field AuthorName.

I wonder if there is a programmatically way in ASP to discover/know
that Authorname is the displayed field of the
rstSchema("FK_COLUMN_NAME").
I hope that this is clear enough.

Thanks.
Irena

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Here's a much simpler method, if you're interested.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Irena" <ne******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Hi all there,

I have developed an ASP script that is able to read the structure of an
Ms Access database ( via object objConn.OpenSchema(27) ) and to
identify the foreign Keys columns and tables (via
rstSchema("FK_COLUMN_NAME") and rstSchema("FK_TABLE_NAME")).

I wonder whether there is a way to read the displayed field name of the
foreign key too.

So to say, for example, in Access, I have a table books. A field of
this table is a "lookup table" type that looks into the foreign Key
FKAuthor of Authors table and displays the field AuthorName.

I wonder if there is a programmatically way in ASP to discover/know
that Authorname is the displayed field of the
rstSchema("FK_COLUMN_NAME").
I hope that this is clear enough.

Thanks.
Irena

Nov 13 '05 #2

P: n/a

Aaron [SQL Server MVP] wrote:
Here's a much simpler method, if you're interested.

Where is?

I visited your site but had no luck in finding an article on the
subject.

Can u specify the article?

thnks.
Irena

Nov 13 '05 #3

P: n/a
Sorry, I hit Ctrl+V but my clipboard must have been emptied somehow...
http://www.aspfaq.com/2520

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Irena" <ne******@hotmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Aaron [SQL Server MVP] wrote:
Here's a much simpler method, if you're interested.

Where is?

I visited your site but had no luck in finding an article on the
subject.

Can u specify the article?

thnks.
Irena

Nov 13 '05 #4

P: n/a

Aaron [SQL Server MVP] wrote:
Sorry, I hit Ctrl+V but my clipboard must have been emptied somehow... http://www.aspfaq.com/2520

--
http://www.aspfaq.com/
(Reverse address to reply.)

Whow! Aaron, you have changed me life with a link! :-)

Thanks.
Irena

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.