Web Development
what are the advantages of using ACCESS 2000 vs. JAVA. please list all!
what r the advantages (if any of using Visual Basic vs ACCESS 2000) please list all and why?
by timwalsh
You are sort of talking apples and oranges here. Java is a programming language. Access is a database program in which you can program functions. Same argument with Visual Basic vs. Access.
BTW, Access relies heavily on Visual Basic for Applications (VBA) for its functionality. If you do any programming within Access, you are using VBA.
Hope this helps.
by tisha2000tt
by peleg
In any such comparision, it is relevant and important to consider what your application needs to do. The requirements will often dictate that, no matter the differences between the languages, one would be the only acceptable choice. Thus, the advantages of one with respect to the other may often depend on what you have to do.
JAVA and VB are both general purpose languages. You can do just about anything in them that your little heart desires and your skill and creativity will allow. Access is specifically a database program. If your application is very data-centric, then Access might be a good choice. If not, then JAVA or VB might be a better choice. It depends on how much data manipulation you have to do. Access is good at that sort of thing, is relatively easy to do, and fast to program. But if you are doing a good bit of number crunching, VB is probably the strongest, although JAVA would probably fare well for this type of application.
Access is a complete, self-contained environment. While you can go outside of Access to get the job done, you can call DLLs from Access, it is complete enough from the data management point of view that this is rarely necessary.
Portability is an issue. While there is a run-time that can be distributed to get your Access apps to run on any machine that doesn't have Access, you can still only install Access on Windows/Intel platforms. As far as I know, VB only runs on the same platforms as Access. JAVA apps can run on almost any hardware-OS combination. Thus, if you have a portability requirement, then JAVA may be the only choice, no matter what advantages the other languages may have. This is a case where requirements may dictate one choice over another.
Speed is not usually a burning issue these days, but VB might have an edge here as it is the only truly compiled language of the three, although with blindingly fast CPUs and intelligent translators
by peleg
I'm a wordy bloke. This was the rest of my answer:
Speed is not usually a burning issue these days, but VB might have an edge here as it is the only truly compiled language of the three, although with blindingly fast CPUs and intelligent translators, the differences in speed would probably only be noticed in a benchmark. Your users would probably not notice a big difference in speed between them, if they noticed at all. The differences here are rather more difficult to discern.
JAVA is a probably the most difficult language of the three to learn, but it is also very powerful and flexible, not that VB is not also powerful and flexible. Being very specific, I would have to say that Access is only powerful and flexible if you are doing a database application.
VB is rather easy to learn, as is Access, but to do a really good job in any of them takes a bit of experience. The big difference here is that for a beginner, it would be easier to end up with something that works, after a fashion, in VB or Access than in JAVA.
JAVA is very object-oriented, more so than VB, and Access only scratches the surface of object-orientedness. If you don't understand objects and classes very well, you aren't going to be very successful with JAVA. You can safely ignore objects in VB and Access and still end up with a good program.
I may have not listed them all, but I hope I have given you something to start thinking about.
by tisha2000tt
by tisha2000tt
This discussion is closed to new replies.
Sort by Trending