John Bartow
john at winhaven.net
Fri Feb 2 09:38:50 CST 2007
Hi Barb, Try the /decompile switch Then close it - open it and compact Also - I'm not sure if 2002 DB could not have Unicode or not but 2003 DB will so that could have been the culprit too. Unicode can essentially double the size of the db. Anyone else know for sure whether 2002 forced Unicode? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan Sent: Friday, February 02, 2007 8:59 AM To: Access List Subject: [AccessD] Database size I just deleted many objects (probably 75 forms, queries, reports) from an Access 2002 database (using Access 2003). I then compiled and compacted. However, the database actually increased in size by 4MG!!! (from 26 to 30MG). What happened? :-( Thanks, Barb Ryan -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: 1/26/2007 11:11 AM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: 1/26/2007 11:11 AM