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?"

4 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 bcat24 · · Score: 3, Funny
      Coffee. Lots of coffee. . .

      With two lumps of LSD.
      I prefer LSD with two spoons of coffee.
    2. 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.