Compacting on A2K vs A2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robert d - 12 Jan 2006 04:16 GMT

I develop my application on my desktop which has Access 2002 (default file
format of A2K). My client uses A2K so I have installed A2K on my laptop.

Recently when developing in A2002 my front end reached about 22 MB in size.
Even after multiple compacts the size only goes down to about 18 MB.

I'm on the road so I started working on the code in my front end using A2K.
I only did about 10 minutes of work, when I got the dreaded "We're sorry for
the inconvenience, blah, blah." So in starting the front end up again, I
noticed that the size had gone from 21 MB to 26 MB in A2K. I had noticed
more bloat with A2K than with A2002 in the past.

I compacted the front end in A2K and the size went down to 10.5 MB!!!? With
A2002 I could only get down to about 18 MB.

Has anybody else seen this type of behaviour between the two versions?

Thanks.

Reply to this Message

Steve Jorgensen - 12 Jan 2006 06:28 GMT

> I develop my application on my desktop which has Access 2002 (default file
> format of A2K). My client uses A2K so I have installed A2K on my laptop.
[quoted text clipped - 14 lines]
>
> Thanks.

I never used A2K enough to notice, but I noticed that Access 2003 seems
to do the best compact of any of them (or at least much better than 2K2).

Reply to this Message

Arno R - 12 Jan 2006 09:18 GMT

> I compacted the front end in A2K and the size went down to 10.5 MB!!!? With
> A2002 I could only get down to about 18 MB.
>
> Has anybody else seen this type of behaviour between the two versions?

This behaviour is 'by design' I guess...
Only yesterday I converted a A2K app to A97 to do some tests.
Size went down from a (compacted) 9,65 Mb to 4,9 Mb

Filesize grows with 'some or all?' version upgrades it seems.

Arno R

Reply to this Message

david epsom dot com dot au - 13 Jan 2006 07:39 GMT

When doing development, you need to do an occasional
'decompile' to get rid of garbage code remnants.

Create a shortcut to msaccess.exe with /decompile
and use that to open your database:

"c:\program ...\msaccess.exe" /decompile

running multiple versions of Access sometimes means
that you have multiple versions of the project inside
the file.

Always decompile and compact before converting.

Converting normally has the same effect as /decompile,
but you should do the explicit /decompile first to
avoid conversion problems.

(david)

>I develop my application on my desktop which has Access 2002 (default file
> format of A2K). My client uses A2K so I have installed A2K on my laptop.
[quoted text clipped - 18 lines]
>
> Thanks.

Reply to this Message