DB Grows,可以自动压缩DB吗?

问题描述:

大家好,


我想知道是否有人曾经历过这个。


当我使用我的数据库时,它继续变得更大。是关闭还是打开时自动压缩数据库?任何帮助都会非常感激。


如果您需要更多信息,请告知我们。

Hello All,

I was wondering if anyone had ever experienced this.

When ever I use my DB, it continues to get larger. Is there away to automatically compact the database upon closing or opening? Any help would be greatly apprecited.

If you need some more information, please let me know.

在Access数据库窗口中转到工具菜单然后选项单击常规选项卡,然后单击关闭时压缩。我还可以告诉你如何在代码中完成它。
In the Access Database window go to the tools menu then Options Click the general tab and click on Compact on Close. I can also show you how it can be done in code if you would like.


你可以在你的浏览器中检查在右键菜单上添加压缩的可能性。

右键单击精简菜单
You might check out the possibility of adding compact on the right click menu when your in explorer.

Right Click Compact menu


感谢您的快速回复。你介意告诉我如何使用代码执行此操作。我似乎无法在选项选项卡选项中找到该选项。我正在使用access 97
Thanks for the quick response. Would you mind showing me how to do this with code. I can not seem to find that option in my options tab selections. I am using access 97