My accdb/accde file no longer compressing when zipped as much as before

I work with an Access 2007 database file that normally runs a file size of 100 to 140 MB in size. Most tables are linked so its mainly the number of forms, reports and coding that makes this file so large. Usually I can compress the accdb file down to about 20 MB and the accde file down to about 15 MB.
All of a sudden I can no longer compress either of these files below 33 MB.  I have decompiled, recompiled, compacted with no apparrent affect. I have gone through and made sure that the local tables had not grown including the system tables.
What else could be going on here that would cause files to no longer compress as much?
LVL 1
BradleyClevelandAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:

Have you made any changes to the DB Structure/Design?
(especially adding Image or file attachments)

Is this an issue with performance?
...or an issue with the space required to back it up?

33MB is almost to small to even matter...

It all depends on what is in the database, and what the DB does behind the scenes.

Also remember that Compacting "rearranges" the file contents (for lack of a better term), clears out the undo buffer, deletes temp objects, ...etc.
So if your DB doesn't generate a lot of temp objects, Has few undos, and was recently compacted, then there is not that much space to reclaim.

In any event, you can also try "DeCompiling" the DB:
http://www.granite.ab.ca/access/decompile.htm
http://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp

But again this amount of compaction taken with the small size of the database is not even worth worrying about, IMHO.

;-)

JeffCoachman
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Try importing ALL objects into a new container (mdb / accdb).

mx
0
 
BradleyClevelandAuthor Commented:
I found that some reports I had been working on which originally had the pictures linked were now embedded. Once I deleted those images, the database compressed as normal again. Thanks
0
 
Jeffrey CoachmanMIS LiasonCommented:
Great!

;-)

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.