How to use an Access database to compress files

Q: Our company uses an Access database uniformly, and it synchronizes data via e-mail, but I find these files to be very large and zip-compressed and very small. I do not know how this is caused by? Is there a better solution?

A: For some operations, access to allocate hard disk space There are some problems, such as not automatically take back the space used, resulting in large files, which may be the cause of the problem you mentioned. You can use the tool (T) "|" in the menu Database Utility (D) "|" Compress and Repair the database (C). In some cases, this can produce unexpected results, and I once compressed a 7MB database file to only 400KB. In most cases, this technique is very reliable, but I strongly recommend that you back up the original data before compressing it.