[AccessD] Swelling database

Barbara - In order to get your database to the minimum size, do this:

1) Go to Tools|Options on the Advanced tab.
2) Select Access 2000 under Default File Format (leave this as a permanent
setting)
3) Close the database.
4) Create a shortcut to open your database.  Add this to the end of the
target field:   /decompile   This will be called your Decompile shortcut.
5) Open the database using this shortcut.  Go to a code module and select
Compile under the Debug menu.  This will optimize your code, removing some
old code behind the scenes.
6) Now compact your database.  You can create a separate shortcut to do this
by adding   /compact   at the end of the target string in the shortcut.
Call this your Compact shortcut.

Once you have these two shortcuts created, you can quickly Decompile,
Compile, and Compact your database.

HTH!
Dan





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Mende
Sent: Thursday, April 03, 2008 9:45 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Swelling database

My little database had 575 text entries and was 968 KB in size this morning.
I added 50 text entries that were like the others, compacted it, and it had
grown to 1924 KB!  I had added some query forms but removed them.  Is
something seriously wrong?  What should I do about it?

Thanks!
Barbara