Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / May 2005

Tip: Looking for answers? Try searching our database.

On a single java file - how to connect to multiple access DB and combine their results

Thread view: 
WUV999U - 25 May 2005 21:18 GMT
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.



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.