What is causing this increase in data base size?

  • Thread starter Thread starter Mike375
  • Start date Start date
M

Mike375

Guest
In a copy I just renamed several field names in a few tables. The db I copied is 18mb compacted. The copy where i changed the field names has grown to 24mb when compacted.

So I imported it to a blank db and still 24mb when compacted.

Could this be because all the queries involved have not been changed. As a side note, on the copy where the field names have been changed I have not opened anything....just the tables in design view to change the field names.
 
Make sure you have the Compact on Close option checked off on the database or it will grow to unbelievable sizes. Find the feature on
Tools - Options - General - Compact on Close
 
It is compacting on close.

I have now changed all the field names required in the forms and queries. Ended up using this tool that PBaldy gave me

http://www.skrol29.com/dev/en_vtools.htm

The db with the field name changes is now compacted at 24mb and the other is at 18mb. Both are identical except for the field name changes that were made in tables, queries and forms.
 
Using the tool to change the table names, queries etc in one go for each field resulted in no growth in the db size as opposed to first chaning the table field names manually.
 

Users who are viewing this thread

Back
Top Bottom