Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: Access is.....

  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: Access is.....

    A piece of junk...sorry just had to vent...it keeps reformatting my sql
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Is this the right forum?

  3. #3
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    oooh i was waiting for Brett's friday new thread.

    can I play?

    Top 10. No particular order.

    ...not a real development platform.
    ...a RAD tool that will eventually choke any project to death.
    ...something I no longer use on a regular basis.
    ...a downgrade from an abacus.
    ...a place where bad VBA written by junior developers goes to die.
    ...a good tool if you are a fan of status bars and oscillating hour glasses.
    ...a good gui for those people without the capacity to learn the basics of SELECT, INSERT, UPDATE, and DELETE. Which begs the question of what these people are doing with database access.
    ...really useful if you want to clog your network and freeze your computer.
    ...is a really useful skillset if you can survive off 35K/year.
    ...is a tool you are forced to use by people who know nothing about software.

    so slow and boring today.
    “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.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    brett, you mustn't've been paying attention

    all access queries should be kept -- and maintained -- outside of access

    paste into the sql window, then run

    changes required to the sql? make them in your text editor, save into your query library, then paste into access and run
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Brett Kaiser
    A piece of junk...sorry just had to vent...it keeps reformatting my sql
    So do the SQL Server GUIs.
    But very rarely do you need to hand-code SQL in Access. Unless you are doing something that cannot be graphically represented (UNION queries, for instance...), just use the GUI query designer.
    If it's not practically useful, then it's practically useless.

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

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    And what's with no unions?

    In any case (and I really should have done this in sql server from the start)

    I have an old access "tool" I built to generate DB2 SQL statements based on excel spreadsheets, because well, no one in HR does any work.

    I need to stop and rebuild all the sql generating templates in sql server sprocs...especiallyu after this last one

    The mainfram really needs dml to be no longer than 80 bytes wide...don't ask, it's just the way it is

    In any case, and I don't know if there's a better way, but when you zoom into an expression, you can do [CTRL]+[ENTER] and that will give you a line break...nd it's always worked...

    Except now...some times it does and sometimes and reformats and removes the break


    I guess I'm pushing Access to hard...and then I hit an upper limit on how big the expression could be

    No Unions...what a piece of junk
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by blindman
    ... just use the GUI query designer.
    extremely handy to build the joins, and maybe selecting a couple of columns

    piece of shit after that

    HAVING ((p.brains)="0")
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    So do the SQL Server GUIs.
    But very rarely do you need to hand-code SQL in Access. Unless you are doing something that cannot be graphically represented (UNION queries, for instance...), just use the GUI query designer.

    There is NO WAY Access could do what I'm trying to accomplish

    GUI's in SQL Server? Never heard of such a thing

    GUI's atre for people who don't know how to code
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Access excels within its niche. It fails when people try to use it for project larger than its ability.
    If it's not practically useful, then it's practically useless.

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

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by Brett Kaiser
    There is NO WAY Access could do what I'm trying to accomplish

    GUI's in SQL Server? Never heard of such a thing

    GUI's atre for people who don't know how to code
    What exactly are you trying to achieve?

    GUI in SQL Server... The query builder is a piece of sh***e; but it's easy enough to avoid.

    Enough of the Access bashing - I wouldn't be a programmer today without that to play around in! And at the risk of sounding cocky, I think I'm getting pretty good at it
    George
    Home | Blog

  11. #11
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I'm with blindman. Access is a tool. It's not the right tool for every job, but it's a very good tool for some jobs. Access does support UNION queries btw.
    Paul

  12. #12
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking

    I have to agree with Brett, the only reason why we are bothering with access cause the former boss was CHEAP. We are really trying to get away from Access this year, the techs are sick of it and how limited it is.
    it was fine when we first got it, its just that we have out grown it. ALLOT
    I have a question Brett, is it an ADP or did you Link the tables??



    EVERYONES INVITED!!!!!!!!!!!!
    Last edited by desireemm; 01-04-08 at 19:34.

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by desireemm
    I have to agree with Brett,
    I have a question Brett, is it an ADP or did you Link the tables??

    Thank you


    I like to link with my spouse

    DB work is a secondary passion...plus it pays the bills

    (And no, linking tables....just look at profiler)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ADP us preferable to linked tables.
    If it's not practically useful, then it's practically useless.

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

  15. #15
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    ...a warm gun

Posting Permissions

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