Solved

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

Posted on 2010-08-25
4
910 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

896 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now