Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-08-25
4
Medium Priority
?
936 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 2000 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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

704 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