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