Solved

How To Access An MS Access Database from a Java Application

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
groupSum6 challenge 6 86
factorial example 4 39
javap not working 8 44
Convert from a json string array to a Java object 3 29
For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

785 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