Database objects are often added and deleted during the design of the database, leaving a lot of fragmentation inside the database, making it more efficient to use disk space, and increasing the file size. This is a bit like the file system after many additions and deletions, resulting in file fragmentation, waste of disk space, and read-write efficiency is reduced. You can use the tools that Access provides to compress the database, which will rearrange the location of the database files in the disk and free up disk space, usually reducing the size of the file to a fraction of the original.
Access has the ability to compress a database, but the increase in access files is exaggerated, which may increase the file by 10 times times and let it stay bloated on your hard drive. This seems to be a common problem for Microsoft. You can open a Word file, add a few spaces and then delete them (the actual file does not change the content), and then save, you will find it more than just a bit bigger, For example, a 45k file after several such changes to the size of the file into 49.5k→58.5k→68.5k, I really do not know what to save in the file. So we have reason to doubt the effect of Access database compression. A year ago I made up a statistical system, with about 3 months, almost every day in the modification, a few days on the compression, and finally this Mdb file has 20M, even the Mde file also has 8M more, I am happy, thinking that they can design a large program. This program to upgrade this year, but the source program let me lose (distressed AH), so determined to make a new one. Features almost unchanged, the last Mdb file size is only 2M more, my God! I can't believe it! The more the original Access file changes the more compressed the file will be larger, what logic! Also, if your Mdb file is too large, you can create a new empty database, the original database all content into the new database, and then see, the file must be a lot smaller. I did an experiment, a 640k Mdb file, compressed the database into 240k, and then build a new database, it all imported, only 60k. Of course, no matter what the above method, Mdb file is very loose, with Winzip can also compress it several times, so, if you want to the program sister to friends, remember the last to use Winzip compression, will not waste your phone fee! (Source: Twin Studios)
