Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 11, 2011 05:34 AM by Decker Dong - MSFT
Apr 08, 2011 11:41 AM|LINK
What happens to the Ms Access file after normalization. I have a had Ms Access File which one table with unnormalized data. After normalizing the table by creating other 4 tables. The file size has increased! is this correct? Why has the file Ms Access File
Please someone to explain so that I understand.
Apr 08, 2011 12:29 PM|LINK
it is natural that the size increases during normalization.
clustering is also increased.
Apr 11, 2011 05:34 AM|LINK
Yes, MS Access will get increased in its size when you add several tables. You cannot avoid it.
BTW：Deleting records frequently will also increase the size because it won't actually delete the records. You should package the database to smallize the size of your db of Access……
You should open your Access DB and select "Tools" --> "Compact And Repair Access"