[AccessD] Database size

Barb,

  Use /decompile.  You've got some dead code in there.  I'm not sure if that
will clean it out or not though.

  Part of the explanation is that when using different versions, Access
actually makes a copy of code, then converts the copy leaving the original
intact.  This happened most notably with A95.  You could delete MSysModules
without problem (MSysModules2 was the live version).

  The other part is that often the connection between objects and the VBA
project breaks leaving orphaned code in the database and nothing gets
cleaned up in the compact like it should.

  At worst, you may have to import everything into a fresh MDB container.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan
Sent: Friday, February 02, 2007 9: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