splitting access database then rejoining it shrinks database size
Posted on 2013-01-14
hey guys, i've got an access database and it's 30MB after compacting and repairing.
so i split it and i get BE 17MB and front end 2MB (both FE and BE compacted and repaired)
1) how come it shrinks?
then i delete all the linked tables in the FE and then import the tables from the BE. i get 19 MB after compacting and repairing
2) how come it's still 19MB whereas the original database is 30MB after compacting and repairing? seems like splitting is necessary to positively shrink the database.
3) if i just delete all the linked tables from the FE and import all the tables from the BE, is that the right way of merging my FE and BE again? by using this simplistic way did i miss out anything? thanks guys!!
edit: sorry guys dumb question, after some searching, i realised there was missing data which contributed to the database shrinking. but could yall help me answer question 3? what's the right way of merging a split database? thanks!