[AccessD] Riddle me this, Riddle me that..

Compression of databases, mde or not relies on the amount of temporary
space used to run queries and other temporary objects.

If an mde uses large temporary objects, compression will be
considerable, simple non-intensive mdes will not, because there is
little temp space to be reclaimed.

More on this here http://support.microsoft.com/kb/q208285/

--andrew  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Sunday, 18 February 2007 12:10 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Riddle me this, Riddle me that..

Ok,
 I have a front end AXP .mde that weighs in at about 27 megs. When I use
Wise to compile a new install with a few other objects, it compresses
the entire install down to about 8 megs.

Now....

 If I take ANY other database, even one created from the objects from
this FE, the .mde does not compress down.


Does anyone have any idea why THIS one FE compresses down, and other
will not...??


Robert

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message.