Slashdot Mirror

← Back to Stories (view on slashdot.org)

How Do I Make Sense of Microsoft Access?

Posted by ryuzaki0 on from the access-denied dept.

Anthony Boyd asks: "I have a pretty good tool-set for LAMP work, but as I get into Microsoft jobs, I've started to wonder if I'm working with the best tools. In particular, I'm exploring an 'out of control' Microsoft Access setup, which has about 200 tables in 30 .mdb files, including some duplicated/outdated tables. I'd like to print the properties of each table (with the comments for each field), print the table list for each database, get info on the field types & relationships, and so forth. What tools do you suggest for trying to grok a large Access mess?"

7 of 100 comments (clear)

  1. Tools by Ricken · · Score: 5, Funny

    "What tools do you suggest for trying to grok a large Access mess?"

    Coffee. Lots of coffee, and ignorance. It's bliss, or so I've heard.

    1. Re:Tools by kfg · · Score: 2, Funny

      Coffee. Lots of coffee. . .

      With two lumps of LSD.

      KFG

    2. Re:Tools by Mistshadow2k4 · · Score: 2, Funny

      No, no, no. You need a case of beer and a large bottle of hard liquor (bourbon, rum, etc.). Coffee makes you realize how little sense Access makes.

      --
      I dream of a better world... one in which chickens can cross roads without their motives being questioned.
    3. Re:Tools by bcat24 · · Score: 3, Funny
      Coffee. Lots of coffee. . .

      With two lumps of LSD.
      I prefer LSD with two spoons of coffee.
    4. Re:Tools by Neoncow · · Score: 3, Funny
      Yes, coffee!

      And pencil and paper and very big pink eraser!
      WTF? This tastes gross! Now I know why you all hate Access so much.
  2. What tools? by Discopete · · Score: 4, Funny

    Fdisk, Format and reinstall. Next time try the SQL desktop engine or Oracle.

  3. how... by syrinx · · Score: 2, Funny

    Evolution of unanswerable questions:

    Middle ages: How many angels can dance on the head of a pin?

    1960's: How many roads must a man walk down?

    2006: How do I make sense of Microsoft Access?

    --
    Quidquid latine dictum sit, altum sonatur.