Solved

How To Access An MS Access Database from a Java Application

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
diffSum example 4 50
Desingning Refactoring existing code 2 26
difference between sorce folder and folder in eclipise 3 28
ejb entity bean example issue 2 16
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…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
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.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

792 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