View Poll Results: Access Vs. VB as Front-end

Voters
6. You may not vote on this poll
  • Access = VBA (Visual basic for Applications)

    3 50.00%
  • VB= Visual basic

    2 33.33%
  • Other (please specify)

    1 16.67%
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Wink GUI Access Vs. VB

    Seeing that the Access Forum is so bussy. And most questions in it are Designd related.
    I was wondering: why would someone choose Access as a front end ?
    And not just as a back-end solution and use Access merely as the database.

    See i'm a VB-man myself so I was wondering how y''all stand.

    The ONLY thing i could think of is that it is "Free" in the sence if you bought Office Pro you get it as a bonus.

    But the REAL question is : How in gods name can (or rather WHY) would an organisation let developers design there solution in Access instead of VB or anny other development-suit.

    So the poll is : What would you rather choose as a front-end development suit : Access Vs. VB (or other)
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    why would people choose access as a front end...

    1. they already have access and have experience with it

    2. they're not a programmer and the only thing they can think of is that VB is some kind of sexually communicated superbug

    3. access is better than fortran

    4. the query builder is da bomb

    5. access reports are drop-dead simple to build

    6. shall i go on?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Talking Lol

    HA HA Verry Funny (in voice of Jonathan Ke Quan : Temple of Doom)
    Quote Originally Posted by r937
    why would people choose access as a front end...

    1. they already have access and have experience with it

    2. they're not a programmer and the only thing they can think of is that VB is some kind of sexually communicated superbug

    3. access is better than fortran

    4. the query builder is da bomb

    5. access reports are drop-dead simple to build

    6. shall i go on? Marvels says : CAN You ???
    So if i read it correctly your saying that Acces is build for people with an IQ less then 82. Just use the wizzard and hope for the best.
    Business guy : If we need an addition we will hire someone who can "program" (mostly a VB-developer).

    So if you want to distibute your "Application", do you burn your mde on a cd ?
    Then how will you start (lets not say install) the app. oh wait offcourse it's only inhouse progamming. Fortunately (hopefully), no one will see it. How crappy it looks. ;-)

    Shall I go on !!!
    Last edited by Marvels; 03-05-08 at 08:16.
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Marvels
    So if i read it correctly your saying that Acces is build for people with an IQ less then 82.
    no, "my" am not saying that

    does VB come with a spell checker?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    One stop shop. It does everything at least competently, some things very well.

    Access - looks crappy? Have you ever seriously shown a client a VB report? I hope you were embarrassed. We are talking classic VB here right not .NET?

    If so I'll give you:
    7. VB 6.0 is deprecated - Access is not. You need an IQ of 82 or less to think VB 6.0 is a viable platform for future development.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Wink Yep it does.

    Quote Originally Posted by r937
    no, "my" am not saying that

    does VB come with a spell checker?
    Just add it to your dependencies and you have a spell checker.
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    my only dependencies are air, food, and appleton's estate v/x

    the reason i asked about the spell checker is that you could use one

    this line has 4 errors: "So if i read it correctly your saying that Acces is build for people with an IQ less then 82."

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    -^.^-

    Quote Originally Posted by pootle flump
    One stop shop. It does everything at least competently, some things very well.
    Thats right : Some things. Query and ODBC's, the rest crashes

    Quote Originally Posted by pootle flump
    Access - looks crappy? Have you ever seriously shown a client a VB report? I hope you were embarrassed. We are talking classic VB here right not .NET?
    Yep, even made a lot of reports in vb5 (Crystal reports was integrated then)
    And do you realy think that when i used vb6 i would use integated reportmanager. C.R. 8 works like a charm. But the Poll was GUI based
    Evenso made a lot of internet based applications that where verry advanced for its time with vb6 ( http://www.db-teg.nl/dbts_projekt.htm )

    Quote Originally Posted by pootle flump
    If so I'll give you:
    7. VB 6.0 is deprecated - Access is not. You need an IQ of 82 or less to think VB 6.0 is a viable platform for future development.
    Access is not!! Its not!?! because its not used to develop out-house. Have you ever got an (paying) develop-assignment and you came back with an CD/DVD with an Access.mde /.mdb on it ???? (Hope not.) Or did you make an setup cd that you developed in a GUI based-enviroment.
    Heck, i'm not telling you either to open Access 2, am I ?
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Marvels
    Thats right : Some things. Query and ODBC's, the rest crashes
    ......

    What's the deal Marvels - have you just been building up to a Troll rampage or something?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  10. #10
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Talking Sorry, did not know you were my English teacher.

    Quote Originally Posted by r937
    my only dependencies are air, food, and appleton's estate v/x
    the reason i asked about the spell checker is that you could use one
    this line has 4 errors: "So if i read it correctly your saying that Acces is build for people with an IQ less then 82."
    But thats what you get for being european, you learn 5 languishes at once growing up, and then you decide to learn a few other like VB ; HTML and Java.

    And talking about dependencies ditto on Air and Food Would add water but rather drink Courvoisier Cognac VSOP or Southern Comfort with 7-up
    Last edited by Marvels; 03-05-08 at 10:10.
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  11. #11
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Wink Hahaha

    Quote Originally Posted by pootle flump
    ......

    What's the deal Marvels - have you just been building up to a Troll rampage or something?
    No man, just messing with u guys.
    But on that subject : Why would Access have a rebuild / repair function, build in it by default ?
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  12. #12
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    why would I choose to use Access...
    well if thats what the customer wants... thats what the customer gets.....
    if they want php likewise

    if they want C, or C++ they can look elsewhere thnakyou very much

  13. #13
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    ditto. I do not care what nonsense they make me do as long as I get paid in the end. Plus I like the pleasure of the I-told-you-so when something does not go well and I raised the flag of using the wrong tool for the job.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  14. #14
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Thumbs up Never had one like that....

    Quote Originally Posted by healdem
    why would I choose to use Access...
    well if thats what the customer wants... thats what the customer gets.....
    if they want php likewise

    if they want C, or C++ they can look elsewhere thnakyou very much
    Never ever had a customer that exactly knew what he wanted.
    They usealy have an genaral idear what they want. And made an assessment that it would Probably be nice to have it in .....
    But leave the decision to someone else.(This way they are covered)

    Does the customer realy knows what the difference is over there ?
    Gee, Paradise really exists

    Headhunters are even struggeling with the difference between Java and javaScript
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Excellent report designer.
    Rapid Application Development.
    Easy upgrade path to SQL Server once the application grows beyond Access's capacity.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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