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
size increased?
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"
Mobzam
Member
93 Points
645 Posts
Whats happens to Ms Access file size after normalization?
Apr 08, 2011 11:41 AM|LINK
Hi people,
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 size increased?
Please someone to explain so that I understand.
jerryjoseph
Contributor
6740 Points
1257 Posts
Re: Whats happens to Ms Access file size after normalization?
Apr 08, 2011 12:29 PM|LINK
it is natural that the size increases during normalization.
clustering is also increased.
http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6VC8-469V2CS-2T&_user=10&_coverDate=10%2F31%2F1992&_rdoc=1&_fmt=high&_orig=gateway&_origin=gateway&_sort=d&_docanchor=&view=c&_searchStrId=1710780561&_rerunOrigin=google&_acct=C000050221&_version=1&_urlVersion=0&_userid=10&md5=3e7b305557a5b59d62d10d631b853243&searchtype=a
linkedin | twitter | www.jerryjoseph.net
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Whats happens to Ms Access file size after normalization?
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"