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!
Who is Participating?
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!!

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...

Dahai528Author Commented:
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?

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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).
what's that got to do with anything?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.