我为什么要关心压缩MS Access .mdb文件? [英] Why should I care about compacting an MS Access .mdb file?

问题描述

我们分发了使用MS Access .mdb文件的应用程序.有人注意到，在MS Access中打开文件后，文件大小会缩小很多.这表明该文件是进行压缩的理想选择，但是我们没有为用户提供进行压缩的手段.

We distribute an application that uses an MS Access .mdb file. Somebody has noticed that after opening the file in MS Access the file size shrinks a lot. That suggests that the file is a good candidate for compacting, but we don't supply the means for our users to do that.

所以，我的问题是，这有关系吗?我们在乎吗?如果我们的用户从不压缩数据库，会发生什么不好的事情?

So, my question is, does it matter? Do we care? What bad things can happen if our users never compact the database?

推荐答案

除了使数据库更小之外，它还会重新计算表上的索引并对表进行碎片整理，这可以使访问速度更快.它还会发现任何不应该在数据库中发生的不一致性，但是可能由于Access中的错误或崩溃而导致的不一致性.

In addition to making your database smaller, it'll recompute the indexes on your tables and defragment your tables which can make access faster. It'll also find any inconsistencies that should never happen in your database, but might, due to bugs or crashes in Access.

这并不是完全没有风险的-一个

It's not totally without risk though -- a bug in Access 2007 would occasionally delete your database during the process.

因此，通常这是一件好事，但请将其与良好的备份例程配对.有了适当的备份，您还可以从任何无法恢复的"压缩和修复问题中恢复，同时将数据丢失降到最低.

So it's generally a good thing to do, but pair it with a good backup routine. With the backup in place, you can also recover from any 'unrecoverable' compact and repair problems with a minimum of data loss.

这篇关于我为什么要关心压缩MS Access .mdb文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！