蒙城华人网

标题: 哪位大侠熟悉ACCESS数据库 [打印本页]

作者: Mason Cheng    时间: 2002-11-5 22:57
标题: 哪位大侠熟悉ACCESS数据库
请问哪位高手如果ACCESS数据库达到文件大小的最大值(1G)以后为什么删除表里的记录不会使数据库文件变小一点?
作者: Liping Liu    时间: 2002-11-5 23:17
请我吃饭我就告诉你。

用COMPACT能使尺寸变小。
作者: Tim88    时间: 2002-11-6 12:04
Just follow the below procedure to compact your access db.

From menu bar, click Tools --> Database Utilities --> Compact and repair database...

Then access will compact your db automatically. It will mainly delete a lot of  "middle tables" generated by itself, i am not sure about this process, anyway, if you're interested, you could get more info from MSDN Library online.
作者: afewgoodman    时间: 2002-11-8 10:48
Actually you can set automatical compact from tool bar tools/option/general/compact at close.

Then the your mdb will be automatically compacted when it is closed.




欢迎光临 蒙城华人网 (https://www.sinoquebec.com/) Powered by Discuz! X3.1