Solved

How To Access An MS Access Database from a Java Application

Posted on 1998-07-15
4
210 Views
Last Modified: 2010-03-30
I use JDK1.2, how can I access an MS Access database from a Java application?
0
Comment
Question by:AmyS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:aziz061097
ID: 1226694
http://www.geocities.com/SiliconValley/Park/9841/jdbc.html

This site has full explanation (using jdbc) and working examples. If you download the Querysrc.zip and compile the java programs and run QueryFrame you can connect to any ODBC database including MS Access and run any SQL command on it.
0
 

Author Comment

by:AmyS
ID: 1226695
Hi! aziz,
Thank you for your help! Could you explain the following in detail?
"If you download the Querysrc.zip and compile the java programs and run QueryFrame you can connect to any ODBC database including MS Access and run any SQL command on it."
I have installed MC Access office 97 in my computer, but I can not find it in 32bit ODBC driver. I compile/run my application programs in DOS. I don't know what the "QueryFrame" is. Need I download the Querysrc.zip?
0
 

Author Comment

by:AmyS
ID: 1226696
10 points to aziz
0
 
LVL 2

Accepted Solution

by:
aziz061097 earned 10 total points
ID: 1226697
Amy ,

    Sorry for not looking in to this . I did not know that you had a question . I hope I had answered to you in detail about connecting an ODBC . If you connect to the site you will see that there is quite some explanation there. The programs explained there can be downloaded and the download format is .zip file. If you extract the zip file you will get a bunch of java files . Compile those java files

javac *.java

and then run

java QueryFrame


0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question