Re: [mdb-dev] seeking help in Ms Access

[Tony T. <tt...@mv...>]

At 09:20 PM 2003/10/27 -0800, Mukesh Kumar wrote:

>I'm not sure whether my problem has any affirmative
>solution but trying to be sure for that.

I'm not at all sure this is the correct forum to answer your question as 
your question seems to have nothing to do with MDB Tools.

If others deem then off topic then please ask your question in a newsgroup 
appropriate to your subject such as microsoft.public.access.queries.  If 
you are unfamiliar with how to use a newsgroup reader you can visit the 
Microsoft Product Support Newsgroups online at 
http://support.microsoft.com/newsgroups/default.aspx.  Click on Office, 
Access and then the appropriate newsgroup to review current postings and 
post your own question.

 >Sometime I require to fetch some data with some condition
 >from a database say "A" and in the same query fetch some
 >data from another database say "B".

One approach might be to created linked files in  mdb "A" pointing to files 
in mdb "B".

Alternatively you would want to use the IN clause.  FROM tableexpression 
IN  "C:\folder name\B.mdb"

There may be some limitations such as
"You can use IN to connect to only one external database at a time."

Alternatively you might want to consider appending tables to a temporary 
MDB and then running your queries against that temporary MDB.

Tony

-----
Tony Toews, Microsoft Access MVP
Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm