compacting an mdb/mde

C

Chuck L

I know this issue isn't very critical compared to Access' other, more
serious limitations and design flaws, but it drives me nuts!

Is there any way to consistently compress an mdb or mde - it looks like
MS simply picks a larger-than-necessary random number and assigns it as
the new mdb/mde size when you compact/repair. I jump back and forth
between compacting with A2K and/or A2K3, which randomly succeeds in
reducing the module size, but is there a reality-based approach to
getting module size accurate, consistent and minimal? It affects upload
time to a website, how much can be stored on a backup flash drive, etc.,
so the problem isn't entirely trivial. Besides, it just drives me crazy
that MS can't even get a module size right!!

TIA for any assistance.

Chuck
 
J

jacksonmacd

When compacting a frontend, I usually hold down the shift key to
prevent any startup code from executing. Then I copy or zip the file.
I've never checked that the file size was exactly the same each time,
but at least I know there won't be any temporary objects created as a
result of any code executing in the database.



I know this issue isn't very critical compared to Access' other, more
serious limitations and design flaws, but it drives me nuts!

Is there any way to consistently compress an mdb or mde - it looks like
MS simply picks a larger-than-necessary random number and assigns it as
the new mdb/mde size when you compact/repair. I jump back and forth
between compacting with A2K and/or A2K3, which randomly succeeds in
reducing the module size, but is there a reality-based approach to
getting module size accurate, consistent and minimal? It affects upload
time to a website, how much can be stored on a backup flash drive, etc.,
so the problem isn't entirely trivial. Besides, it just drives me crazy
that MS can't even get a module size right!!

TIA for any assistance.

Chuck
**********************[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
T

Tony Toews

Chuck L said:
I know this issue isn't very critical compared to Access' other, more
serious limitations and design flaws, but it drives me nuts!

Is there any way to consistently compress an mdb or mde - it looks like
MS simply picks a larger-than-necessary random number and assigns it as
the new mdb/mde size when you compact/repair. I jump back and forth
between compacting with A2K and/or A2K3, which randomly succeeds in
reducing the module size, but is there a reality-based approach to
getting module size accurate, consistent and minimal? It affects upload
time to a website, how much can be stored on a backup flash drive, etc.,
so the problem isn't entirely trivial. Besides, it just drives me crazy
that MS can't even get a module size right!!

Try doing a decompile. Then when going into the database hold down
the shift key so it doesn't start any code running. Finally compact
it. That will the minimum possible size. Mind you before anyone
should start using it should be compiled.

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
C

Chuck L

Tony said:
Try doing a decompile. Then when going into the database hold down
the shift key so it doesn't start any code running. Finally compact
it. That will the minimum possible size. Mind you before anyone
should start using it should be compiled.

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

Tony
Thanks - decompile helped a lot.
Chuck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top