-
DB too large
Hi,
I have an application which is written in Access. It was always around 5MB (the mdb file, the mde around 3.5). Today, I just made a simple little change (no new object, just small code change) and the database grew to 21MB.
Any Ideas why?
I can't have it that bid.
Thanks,
-
Did you just delete a bunch of records, perhaps more than once? Deleted records are only removed from sight and not actually deleted until the database is compacted, so you might try compacting the database.
-
Dude, it's Access.
No explanations. The things I've had to deal with.... but those days are behind me. :wave:
-
Yes, it's Access, he he he. The client had this thing done in Access and they don't want to pay for rewriting so we're stuck with this thing.
No, the application doesn't contain any tables just table links.
I ran compact repair, decompiled the damn thing, nothing.
-
What was this "small code change"?
-
Never mind.
The main form has their logo on it.
They recently sent me a new image file to replace the old logo.
I just realized that it's 800KB and the old one was 20KB.
I resized the image file and now it's fine.
I can't believe that the file size jumped from 5 MB to 21 MB because of a difference of 780KB in an image file.
Thanks,