[AccessD] Database size

Dan Waters dwaters at usinternet.com
Fri Feb 2 22:22:18 CST 2007


Barb, if you can change the database format to Access 2000.  Then try
decompile/compile.  Then compact.

There was an issue in 2002 which, I think, prevented decompiling if the
database was in 2002 format, but worked fine in 2000 format.

Dan Waters


-----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




More information about the AccessD mailing list