• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

MS Access & Java

 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 1071
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 2166
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic