Dude, I ate too many baked beans for lunch....Oh, wait, wrong topic.
I've been stymied over the last week by my Access database growing
from 1.7MB in size to over 34MB. Miraculously, I actually saw it
happen today in the blink of an eye. Since I knew what I had just
changed, I realized the issue was with a picture embedded in the
database.
You would think that a 560kb picture would only take up - yes - 560kb.
No, apparently it takes microsoft 32,000kb to fit that 560 into. Once
I linked the image instead of embedding it and then compacted the
database, it shrunk down to its pre-bloated state.
Maybe this is the same thinking that led Microsoft to spend $300
million on a pointless, dumb ad with Seinfeld and Bill Gates. And to
think, all they needed was a pizza box. [Links to come when I'm not on
my iPhone.]
Sent from my iPhone