[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
>