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

Joining two tables from two different database using ASP?

P: n/a

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
------------------------------------------------------------------------

Jan 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
------------------------------------------------------------------------

Jan 23 '06 #2

P: n/a
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

Jan 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.