[AccessD] Database size

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
 




More information about the AccessD mailing list