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 MS Access & Java 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 "MS Access & Java" Watch "MS Access & Java" New topic

MS Access & Java

Robin Richardson
Ranch Hand

Joined: Mar 01, 2001
Posts: 37

I'm sure this or a similar question has probably been asked already, but I couldn't find it.

I am taking a class where we are using MS Access 2003 as the database, we are trying to determine the best language to use for our program (genealogy program). The question is if Java would be an appropriate language to use. While I think that in this case VB for apps or VB.NET would probably be the better choice (our other 2 choices), I was wondering if Java would be out of the question. The idea is to develop a stand alone program, not an Enterprise or SQL Server application.

Thanks in advance.
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

A standalone app with Access? VBA is the best fit, though IMHO developing anything with Access is more pain than its worth.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Steven Bell
Ranch Hand

Joined: Dec 29, 2004
Posts: 1071
Java isn't out of the question with Access, but I don't think it would be the preffered choice either. I agree with Paul that VBA would probably be the best bet. Although I would try and make the case for a real DB. There is a program called Access2MySQL Pro that would give you a MySQL DB in about a minute (five free conversions before you have to buy a license, but you would only need one.). Of course it's usually not possible to get a change like that to happen in a classroom setting.
Axel Janssen
Ranch Hand

Joined: Jan 08, 2001
Posts: 2164
Agree with Paul.
Out of topic, but never mind:
For Java there are small openSource sql-databases, which are worth a try.
My favourite is:
There is also apache Derby now.
Robin Richardson
Ranch Hand

Joined: Mar 01, 2001
Posts: 37
Thanks for the answers. Unfortunately, this is a college class and the set up is for MS Access. I hope to work on using MySQL or Cache, and study Java more on my own.

I agree. Here's the link:
subject: MS Access & Java
It's not a secret anymore!