[mdb-dev] seeking help in Ms Access

[Mukesh K. <muk...@ya...>]

Hallo Everybody,

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

My problem is

I've more than 5 database in MS Access
I require to fetch some information from each database

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

So the query may be like as follows
"select
Database_name_A.Table_Name_a.Column_name_aa,Database_name_A.Table_Name_a.Column_name_bb,Database_name_B.Table_Name_b.Column_name_aa,Database_name_B.Table_Name_b.Column_name_bb
from Database_name_B.Table_Name_b,
Database_name_B.Table_Name_b where clause"

Now database_name_A is in "c:\A.mdb", database_name_B
is in "c:\B.mdb"

I know this is possible in SQL server as the select
command is like
"select database.table.fields,database.table.fields
from database.table,databse.table where clause"

But the problem with MS Access is it creates one
databse with onle file. Means we cannot create
multiple database in a single MS Access file.

SO MY PROBLEM IS THERE ANY WAY TO CONSTRUE A SQL QUERY
TO EXECUTE MULTIPLE DATABASE (EACH DATABASE IS A 
SEPERTE FILE ON A LOCAL SYSTEM'S HARD DISK) IN MS
ACCESS?

Thanks you,
Mukesh Kumar

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com