Solved

How To Access An MS Access Database from a Java Application

Posted on 1998-07-15
4
176 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
Comment Utility
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
Comment Utility
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
Comment Utility
10 points to aziz
0
 
LVL 2

Accepted Solution

by:
aziz061097 earned 10 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
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…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now