[AccessD] Compact/decompile

KB 810415

...there is a long standing bug in AXP that compile fails to get rid of
bloat if you use the A2002 file format ...MS hasn't fixed it in their
service packs even though they have a KB on it and importing into a new mdb,
although a pita, is the only way to get rid of the bloat ...OR change to
using the A2000 file format which does not have the bloat problem ...HTH :)

William Hindman
So, then, to every man his chance -- to every man, regardless of his birth,
his shining golden opportunity -- to every man his right to live, to work,
to be himself, to become whatever his manhood and his vision can combine to
make him -- this, seeker, is the promise of America.
-- Thomas Wolfe



----- Original Message ----- 
From: "Stuart Sanders" <stuart at pacific.net.hk>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, October 20, 2003 11:26 PM
Subject: [AccessD] Compact/decompile


>
> Just goes to show that sometimes you just have to import into a clean
database.
>
> I had a fairly mature database that I wanted to cull everything out of
except
> the table links and a few forms/tables/queries/modules for system tools,
link
> checking etc.
>
> Deleted everything and the sink ecept for the few things I wanted.
>
> Compacted ... 14.6 MB .  Hmmm should be smaller than that.
>
> Decompile. Exit. Reload. Compact.  14.1 MB
>
> Tried a few more things.  In the end gave up and imported everything out
of the
> 14.1 MB bloat and into a new mdb.  Reset links. Compile. Compact. 1.1 MB
>
> 14.1 MB -> 1.1 MB
>
> This is in access XP.  I think they still need to work on their cleaning
utils.
>
> Stuart
>


----------------------------------------------------------------------------
----


> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>