seeking help

[mukeshakumar]

Hi 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.C
olumn_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
(e-mail address removed)

 

[Dale Fye]

Check out the IN clause of SELECT statement. The following statement
selects all the records from the NewColumns table in the
'denormalize.mdb' file. My guess is that you can extend this to
multiple tables/databases, but have never tried it myself.

SELECT * From NewColumns IN denormalize.mdb

--
HTH

Dale Fye


in message Hi 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.C
olumn_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
(e-mail address removed)