File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Java GUI and MS access database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Java GUI and MS access database" Watch "Java GUI and MS access database" New topic

Java GUI and MS access database

mansi gupte
Ranch Hand

Joined: Dec 30, 2008
Posts: 72

I need your help, actually , a direction.
I have MS Access database that i am working on.Also, i am learning Java GUI (swings basically) . I need to connect these two, so that i can get a sophisticated application that can show tables, run query, print reports, using Java GUI.

Any idea, how do i start. What all things will i need? Any good resources where i can read up and work.I am pressed on time. I still have to complete the database, and can start after that.
This is my next project on hand.Currently, i am using MS Access forms and reports, but i want to improve.
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46410
mansi gupte wrote:. . . I am pressed on time. . . .
You need time to learn it. You can't rush it. There are examples in many of the books, eg Deitel and Deitel, Horstmann and Cornell. I would suggest you find something free (see whether MySQL is still available) and go through the Java™ tutorials.

Not that they use Access. Do you really need to use Access?
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
I would agree with the sheriff , avoid access if you can. I was forced to write an app using access and it
would crawl if you did any table joins.

Good luck

Bill Karwin
Ranch Hand

Joined: Aug 02, 2010
Posts: 32
mansi gupte wrote:MS Access database ... Java Swing GUI ... Any idea, how do i start. I am pressed on time.

I've been developing software for thirty years. I've always found that learning a new language or library or tool from the ground up requires a lot of time to experiment and practice. I can't focus well on learning new stuff while I'm trying to concentrate on developing a working application at the same time. Instead, I need to take some time to read the docs, try all the functions using throwaway code, and see how they work. Then when I'm comfortable with using the tools and language, I can start putting it together to build the application I wanted to build.

If you are pressed on time, then you'll just get frustrated and also create a really bad application. You should just get an application that's already working and does what you need. If you use an open-source app, you can learn further by reading the code.

So if you're ready to invest some time to learn to write Java applications to interact with an MS Access database, start with a web search with the word "tutorial" combined with the technologies you have in mind. For example, "microsoft access java tutorial" yields some promising articles:

"Java and Microsoft Access SQL Tutorial"
"Access Database Manipulation via JDBC"

Bill Karwin is the author of SQL Antipatterns: Avoiding the Pitfalls of Database Programming
I agree. Here's the link:
subject: Java GUI and MS access database
It's not a secret anymore!