[AccessD] Compact/decompile

...yeah, besides the cretinous "help" system, its the only real fault I've
found with XP which is why I migrated everything to it but still use the A2K
file format ...simply unbelievable that MS hasn't fixed such a major bug :)

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: Tuesday, October 21, 2003 12:16 AM
Subject: RE: [AccessD] Compact/decompile


> Yeah this seems to be the issue.
>
> For the most part my dbs are in Acc2000 format.  Except this one and it
isn't
> small, so it never really hit me until I tried cutting out 95% of it and
> compacting.
>
> I've had issues with AXP crashing on couple of forms that A2K doesn't
blink at,
> and haven't figured why ... Nor looked that hard when staying in A2K
format
> fixed it.  Might also be related if AXP is leaving so much crap behind.
>
> Stuart
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > William Hindman
> > Sent: Tuesday, 21 October, 2003 11:47 AM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [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
> > >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com