HI
I have a question on JAVA.
I am wondering how how to connect to multiple access databases and
combine their result on a single java program or file,,,
I will be glad if someone would help me on this,,, greatly appreciate
ur help.
Thank you very much.
Warm regards
Dag Sunde - 25 May 2005 22:13 GMT
> HI
>
[quoted text clipped - 6 lines]
> ur help.
> Thank you very much.
I'm not sure what you mean by: "> combine their result on a single
java program or file,,," but if you know how to open and query one
Access db, you already know the answer; Just repeat what you did for
the rest of your databases.
On the other hand, there might be a better way for you to do this, if
the table-structure of the databases are (reasonably) stable.
* Create an empty db, and call it "master" or something.
* Right-click on the table-window, and select "Link Tables..."
* Select your other db's (one by one), and link all their tables
to this "Master" database.
* Save it.
Now, you can use only one db, namely "Master.mdb", which contains
all the tables from all the other .mdb databases. This enables you
to do heterogenous queries on several databases at once.
hth...

Signature
Dag.