Joining two tables from two different database using ASP?

[Coquette]

Hi all. I'm new here. I wanted to ask your opinion about *joining two
tables* from *two different database* together. Is *that* possible? My
project requires me to join identical tables from different database;
*eg. MyTable* from *Friends.mdb* and *Foes.mdb* respectively. Is that
achievable? I do hope anyone here can enlighten me on this one because
I am really a newbie in using Access DB and also I'm using *ASP* in
this project. Hope anyone here can give me starters for to me to start
on. :)

--
Coquette
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

[dNagel]

You may have to investigate using a database link from one MDB to the
other. Aside from that I've been using ColdFusion for a while and it
offers a means to do an in-memory query consisting of multiple already
executed recordsets. I do not know if ASP offers a similar facility.

D.
Coquette wrote:

Hi all. I'm new here. I wanted to ask your opinion about *joining two
tables* from *two different database* together. Is *that* possible? My
project requires me to join identical tables from different database;
*eg. MyTable* from *Friends.mdb* and *Foes.mdb* respectively. Is that
achievable? I do hope anyone here can enlighten me on this one because
I am really a newbie in using Access DB and also I'm using *ASP* in
this project. Hope anyone here can give me starters for to me to start
on. :)

--
Coquette
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

[paul]

At first I didn't think it could be done, but I actually tried it and
it worked:
http://www.sitepoint.com/forums/showthread.php?t=101500

Best regards,
-Paul
www.Bullschmidt.com - Freelance Web and Database Developer
www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips