Solved

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

Posted on 2010-08-25
4
918 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:BradleyCleveland
  • 2
4 Comments
 
LVL 75
ID: 33525378
Try importing ALL objects into a new container (mdb / accdb).

mx
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 33527175

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
 
LVL 1

Author Closing Comment

by:BradleyCleveland
ID: 33533972
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33536389
Great!

;-)

Jeff
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question