Results 1 to 6 of 6
  1. #1
    Hye
    Guest

    Visual Basic vs ACCESS (N/A)

    Any "Loungers" out there that can help me answer and put to rest an ongoing feud I am having at work (the Hatfields vs. McCoys). I have had several heated discussions in the office about the virtues (pros and cons) of ACCESS verses Visual Basic. I have been told a number of times that ACCESS is worthless and that VB is the "only way to go" for developing new systems. My question is where can I find out about or research the strengths and weakness of both products, why is one product better than the other product and under what circumstances should one be considered over the other? Please advise on best approach to research or give me your opinions.

    Thanks. George

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Visual Basic vs ACCESS (N/A)

    How about starting with <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=vb&Number=62791>this thread</A>.

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Visual Basic vs ACCESS (N/A)

    Define the scope. If the app will be used in an office environment, over a LAN, Access will provide years of happy service. It's not a bad query tool as well for departmental users. VB is not a real productivity booster for end users.

    On the other hand, (as far as I know) few developers are using Access to develop web-based apps whereas, VB (and it's successor -- .Net) are slouching ever more decidedly toward all things internet.

    Such as statement as you are hearing reveals a bit of ignorance on the part of them thar Hatfields.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Visual Basic vs ACCESS (N/A)

    Unfortunately, it's all too common among those who learn VB first and see it as a Swiss army knife. They tend to forget that they're using the same database engine by default except it's much more work to teach it the tricks that Access already knows. You can drive nails with a chisel, too, but a hammer is a LOT easier to use. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I've even had them insist that they can do something in VB that won't work in Access ... because the table structure prevents it!! This is what a favorite author of mine refers to as "willful ignorance" ... they just don't want to know. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Visual Basic vs ACCESS (N/A)

    Why compare a programming language to a database management tool. They both have their function. Avoid the wasted time on debates like the ones you mention.

    That's like comparing MacroMedia Freehand to PowerPoint, or QuickBooks to Excel.

    Just my thoughts.

  6. #6
    Hye
    Guest

    Re: Visual Basic vs ACCESS (N/A)

    Thank You to all: for your comments and thoughts. Good stuff !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •