• barfman (unregistered)

    I beg to differ.. you COULD polish this particular turd, but after you were done, the application would no longer exist.

  • (cs) in reply to David
    David:
    Hi Tony & Maz2331. I'm doing some work with Access, but I'm very inexperienced. I've never been given any formal training in Access, so I'm relying on general computer science knowledge. You've stated several things that "of course" you should or should not do (eg basing forms on tables), but they're new to me. Can you point me to a resource that explains these best practices for using Access, preferably with explanations of why the practices are good or bad? I'd greatly prefer to do things right, but it's unlikely to happen by voodoo magic and luck.
    Hmm, that's a bit of a tough question for me as I've worked as a programmer/systems analyst/developer/whatever for umm, yikes, almost thirty years.

    I'd start off at the Microsoft Access site http://office.microsoft.com/en-ca/access/default.aspx?ofcresset=1 looking at the Help and How-to pages on the left hand side.. There is also the Technical Resources section.

    To get one on one help though click on the Discussion Groups link and choose a relevent area within the Access database. That's where Albert, myself, many fellow Access MVPs and other experts hang out. We'd be happy to help you out. I have about 36,000 postings in the newsgroups almost all of which are Acces related.

  • (cs) in reply to Tony Toews
    David:
    Can you point me to a resource that explains these best practices for using Access, preferably with explanations of why the practices are good or bad? I'd greatly prefer to do things right, but it's unlikely to happen by voodoo magic and luck.

    There's also a yahoo group called AccessDevelopers http://tech.groups.yahoo.com/group/AccessDevelopers/

    And here's a library full of Access examples: http://www.rogersaccesslibrary.com

  • tina (unregistered) in reply to David

    in addition to Tony's suggestions, you can find an excellent list of resources at http://www.accessmvp.com/JConrad/accessjunkie/resources.html

    and don't forget to bookmark http://www.mvps.org/access/

  • (cs) in reply to Albert D. Kallal
    Albert D. Kallal:
    Why? Ms-access is just another development tool. You can choose c++, vb, or ms-access to interface to sql server. Perhaps you new to computers, but it seems like you can’t even understand the difference between an access application, and that of a database. Ms-access is not a database, it is a development tool. I think perhaps you talking about a JET database here. When you use ms-access, or vb (or a php web site), you still can choose your database engine. You don’t have to use JET as the database engine here, you can use your sql farm. There are ms-access applications with 1000 simultaneous users that run just fine. You just have to make sure you have a decent database server (but, that server has little, or nothing to do with vb, ms-access, or your php web site). I really amazed that you lack basic computer understanding here!

    The database you use with ms-access might be Oralcle, ms-sql server, or JET. If you use sql-server, then why would the sql run slower when using ms-access, or c++, or a web site and php? (or, for that matter hand coded assembler!).

    Somehow you think that the sql server or oracle actually knows that ms-access is on the other end and then decides to run slow?. Golly, come on! If you going to be smug and criticize things here, as least show that you have better ability then the “Sharon” person. Really, your lack of understanding is actually WORSE then Sharon because you critiquing under the guise of smugness, and being a know it all (yet, you don’t even understand the basic difference between an development tool like ms-access, and that of the database you use with that tool.).

    You should try and keep in mind the difference between a development tool like ms-access, and the database engine you decide to use with that devepument tool.

    So, sure..be critical, but use caution, else we have to bring up the story about calling the kettle black, and someone who lacks a basic understanding of VB, c++, ms-access and that of Oracle, sql server, or JET.

    It begs the question who needs some education here.

    Albert D. Kallal Edmonton, Alberta Canada [email protected]

    By sheer good luck, I have some time to spare. You appear to be either within the Canadian educational establishment, or otherwise interested therein.

    You also appear to be an unthinking moron. I have relatives in Canada, and I don't want you running loose.

    Please contact at [email protected].

    Thanks ever so much.

  • Roger Carlson (unregistered) in reply to real_aardvark
    real_aardvark:
    By sheer good luck, I have some time to spare. You appear to be either within the Canadian educational establishment, or otherwise interested therein.

    You also appear to be an unthinking moron. I have relatives in Canada, and I don't want you running loose.

    Please contact at [email protected].

    Thanks ever so much.

    Albert an unthinking moron? ROFL! I suppose a "real aardvark" might think so.

    Albert has given reasoned arguments for his stance and your contribution to this thread is...oh wait...you haven't contributed anything, have you?

  • Nippeltwig (unregistered)

    I agree, the girl is cute.

  • SmokeySmith (unregistered) in reply to BigPimpin'
    BigPimpin':
    Microsoft Access - A WTF all by itself. Anyone that actually puts a multi-user system into production that's written in Access is an idiot.

    I know Sharon, and she actually moved on to work for Diebold, where these Access macros were modified to handle the 04 election counts and security.

    http://blog.wired.com/27bstroke6/2007/04/diebold_vote_da.html

  • Keith (unregistered) in reply to ParkinT

    I think your quote may be wrong. If given the option of two I would go with Fast and Right...

  • (cs) in reply to Anonymous Coward
    Anonymous Coward:
    gwenhwyfaer:
    Rhett:
    WTF does this all have to do with Dougie Howser?
    Well, you know how some people think they can perform surgery because they've watched a lot of medical dramas? Some people have the same delusion about software...

    Some people think they can actually write software after they've watched a lot of medical dramas?

    Sad to say, from some of the code I've seen, this appears to be true. The give-away, of course, is the comments and/or variable names.

  • (cs) in reply to foxyshadis
    foxyshadis:
    FredSaw:
    BigPimpin':
    Microsoft Access - A WTF all by itself. Anyone that actually puts a multi-user system into production that's written in Access is an idiot.
    Access was still in fairly common use in 1998.
    Access was still in fairly common use yesterday, more's the pity.

    The real problem is that access's JET database will still be in fairly common usage in production, multi-user applications yesterday, today, and [b]two years from now[b].

Leave a comment on “The Sharon System”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article