This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Access & Java

 
Robin Richardson
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A standalone app with Access? VBA is the best fit, though IMHO developing anything with Access is more pain than its worth.
 
Steven Bell
Ranch Hand
Posts: 1071
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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: http://hsqldb.sourceforge.net/
There is also apache Derby now.
 
Robin Richardson
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Robin
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic