数据库自动备份并压缩_快速提示：自动压缩访问数据库

数据库自动备份并压缩

Although it’s unlikely that you’ll ever hit the maximum Access database size of 2GB, it’s still good to know that you can set your database to automatically compact or shrink the file size. This is especially true for databases where you are adding and removing a lot of data each time.

尽管不太可能达到2GB的最大Access数据库大小，但还是很高兴知道您可以将数据库设置为自动压缩或缩小文件大小。 对于每次要添加和删除大量数据的数据库而言，尤其如此。

To enable the automatic compact, open your Access file and go to Tools \ Options.

要启用自动压缩，请打开Access文件并转到“工具” \“选项”。

Select the General Tab and place a checkmark in the box next to “Compact on Close”

选择“常规”选项卡，并在“关闭时紧凑”旁边的框中打勾。

That’s it! Now each time the database is opened it will automatically compact the data when you close Access.

而已！ 现在，每次打开数据库时，它将在关闭Access时自动压缩数据。

翻译自: https://www.howtogeek.com/howto/microsoft-office/quick-tip-automatically-compact-access-databases/

数据库自动备份并压缩