Hi, I am an amatuer programmer that would like to develop some desk-top data base applications and distribute them (for the foreseeable future for free) to other users.
So far, I have spent a lot of time developing distributable databases with Access 2002/VBA (with the runtime license provided under XP Office Developer). I know what I'm doing with Access 2002/VBA, but the problems of distributing run-time versions of Access for these applications (ie, conflicts with versions of Access on end-users' machines) have been a big disincentive for installation of these applications. So I'd like to start over with something that end-users can install with fewer problems/issues. I have been considering three alternate paths and would really appreciate input from the experts:
1) I could continue to work with Access/VBA, if the latest version of run-time Access is easier for users to install, but I doubt this is the case.
2) I could use VB .NET or VB 2005 to develop a true stand-alone application, but where would such an application derive its database functionality? Would I still have to distribute run-time Access with it for it to run, or do VB .NET/VB 2005 have some kind of internal database functionality?
3) I would also like to learn Java and have considered using Java with MySQL. This sounds rather clunky, and it seems like users would have to install two applications (my Java app and MySQL), which would be a drawback.
Thanks in advance for your feedback; be prepared for a couple of follow-up questions!