Compacting a accdb does not result in a smaller file

[HH]

It seems like the compact function in Access 2007 is less powerful then a it
was in earlier releases, like Access 2003, Access XP and Access 2000.

My application executes a lot of INSERT and DELETE statements and the file
size increases quickly from 2Mb to over 50Mb. In earlier releases the file
size comes back to 2Mb after compact, but now it does not.

I already checked the Help in MS Access, table MSysCompactErrors does not
exist and opening the application 'exclusive' does not show any difference.

Hope somebody has similar experiences and found a solution for this.

 

[Tom Wickerath]

Hi HH,

I can't say that I have heard of any compact problems in A2007, but I also
do not have any databases in production, using A2007.

That said, it sounds like your app. might be storing temporary data, perhaps
as part of the calculation of a final result? If this is true, you may be
able to prevent a lot of this bloat by using a temporary linked database,
instead of adding & deleting records from your working database. Here is an
example that you can download from my web site, if you are interested in
using a temporary database:

http://www.accessmvp.com/TWickerath/downloads/tmpwrkdb.zip



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[HH]

Tom,

Thanks for your reply, but I do not like to work with a temporary database
etc. I can not understand why the compact function seems not working properly
in Access 2007. My application has not been changed at all and the compact
function has been working properly in previous releases of Access and was
helpful to reduce the amount of data significantly.