Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win



Posted on 2004-10-28
Medium Priority
Last Modified: 2006-11-17
I'm tring to develop a java application system to connect with Ms Access, and to get or change database's information.
I knew there're lots of ways to come true this. But I'd like to use DAO with COM object or JDBC.
 I don't know which one is better on my project?
Can anybody give me an advice?
or Is there any better way to come true this project.
Thank you very much!
Question by:Dahai528
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 35

Expert Comment

ID: 12431945
I'd use JDBC...

As soon as you try to add COM to your java project, you are adding a level of complexity that unless it is absolutely necessary, isn't worth doing...

I'd suggest Hibernate, but that doesn't work on MS Access databases...


Author Comment

ID: 12432032
Thank you Tim.
I knew JDBC is a fast and easy way to connect with database and to get information. But Can JDBC get SQL Statement from Ms Access Query/View Component?
And Can JDBC get Ms Access Form/Report Component Information? (I can't find)
If it can, How?

LVL 35

Accepted Solution

TimYates earned 2000 total points
ID: 12432090
Off the top of my head, I'd say that it can access the Views, as Views are normally seen as just another table...  

The form/report stuff is another area though, and I don't think you can :-(


a) do some form of java reports/forms instead of using the access ones...
b) use something like Jacob (http://jacob-project.sourceforge.net/wiki/index.php/Main_Page) to access the COM infrastructure as you originally said...

Hopefully some other expert with better knowledge in this area can jump in and help....I have never used MS Access with java...

Good luck!!

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

LVL 21

Expert Comment

ID: 12432123
The JDBCOdbc bridge will have access to your Tables (maybe your queries) only.  The forms and reports will have to be reverse engineered.  

For the reports, I would suggest some sort of reporting framework (e.g http://jasperreports.sourceforge.net/).

For the forms, either a servlet with HTML screens OR a swing application (there may even be a form framework for swing).
LVL 35

Expert Comment

ID: 12432896
what's that got to do with anything?

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
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.
Suggested Courses

618 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