I noticed a bug in the compact routine for access 2007. It seems if the
database resides in a trusted folder, it doesn't compact fully. Try copying
the database to a non-trusted folder, like the desktop, compact it, then
check the size. You can then move it back to the normal location.
This bug doesn't look like it was addresses in SP-1.
Hope this helps,
"Les Desser" <Ne*******@dessergroup.comwrote in message
news:me**************@dessergr0up.invalid...
In article
<b9**********************************@m36g2000hse. googlegroups.com>, HH
<ha***********@hwits.nlTue, 6 May 2008 00:38:01 writes
>>It seems like the built-in compact function does not compact at all. A
mdb file made under 2003 has been grown to over 100Mb. Compacting in
access 2003 results in a file smaller then 5Mb. Campacting the same
file under 2007 does not become smaller at all.
Maybe it first has to be converted to 2007 format for A2007 to compact it.
--
Les Desser
(The Reply-to address IS valid)