
access program database shrink in Access 2000
Quote:
>But I do recompile and compress my db's every time I am adding code to them
>, I am sure that's not the point BTW the mde files shrink in the same
>proportion
>do you also recompile your mde files *all* the time :-)
>>You'd Probably get a similar reduction by running /DeCompile & Compact
>>on your '97 version
No, Peter is talking about /decompile. Much different. This has
saved me 10% or 20% of space even after doing compresses. And I run
that reasonably frequently.
If you've never run it before it could save you 50% or more on a front
end MDB.
Tony
----
Message posted to newsgroup and, if appropriate, emailed.
Tony Toews, Independent Computer Consultant
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
VolStar http://www.volstar.com Manage hundreds or
thousands of volunteers for special events.