Java GUI and MS access database

[mansi gupte]

Ranchers!

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]

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]

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

Agad

[Bill Karwin]

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" http://www.programminglearn.com/224/java-and-microsoft-access-sql-tutorial
"Access Database Manipulation via JDBC" http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2