Solved

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

Posted on 2010-08-25
4
924 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

752 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