By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

Compacting on A2K vs A2002

P: n/a
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200601/1
Jan 12 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
robert d via AccessMonster.com wrote:
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.

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).
Jan 12 '06 #2

P: n/a

"robert d via AccessMonster.com" <u6836@uwe> schreef in bericht news:5a3a93085c0aa@uwe...
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
Jan 12 '06 #3

P: n/a
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)
"robert d via AccessMonster.com" <u6836@uwe> wrote in message
news:5a3a93085c0aa@uwe...
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200601/1

Jan 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.