Solved

How To Access An MS Access Database from a Java Application

Posted on 1998-07-15
4
206 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
  • 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

Independent Software Vendors: 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

Title # Comments Views Activity
Better way to make a string with template variables in java 3 31
Java program running SQL query 5 46
Tagging and Merging on Branch 1 39
Java array 10 54
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
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…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

679 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