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