数据库的大小 [英] size of database
问题描述
我使用大小为250MB的MS ACCESS数据库。 dababase包含
60个表，没有其他对象。此数据库中的对象不能更改为
。我希望减少数据库的大小并删除所有60个表中约50％的
记录，但此数据库的大小仍为250MB。可以
有人告诉我为什么以及如何减少它。
谢谢
尝试：
工具|数据库实用程序|紧凑
-
Allen Browne - 微软MVP。西澳大利亚州珀斯。
访问用户提示 - http：// allenbrowne.com/tips.html
回复群组，而不是mvps dot org的allenbrowne。
" john_liu" <乔****** @ charter.net>在消息中写道
新闻：lD ******************* @ fe06.lga ...我用一个大小为250MB的MS ACCESS数据库。 dababase由60个表组成，没有其他对象。无法更改此数据库中的对象。我想减少数据库的大小并删除所有60个表中大约50％的
记录，但是这个数据库的大小仍然是250MB。
有人可以告诉我为什么以及如何减少它。
john_liu写道：
我使用大小为250MB的MS ACCESS数据库。 dababase由60个表组成，没有其他对象。无法更改此数据库中的对象。我想减少数据库的大小并删除所有60个表中大约50％的
记录，但这个数据库的大小仍然是250MB。可能有人告诉我为什么以及如何减少它。
如果您使用的是Access 2000或更高版本：
得到工具 - >数据库实用程序 - >压缩和修复数据库
访问数据库引擎MS Jet，当
$时不会放弃climed空间b $ b记录被删除。上述过程是必需的。即使没有
删除任何记录，上述过程也应该减小大小，因为
数据库会根据所执行的活动而略微膨胀。
-
Tim http：// www。 ucs.mun.ca/~tmarshal/
^ o<
/＃）Burp-beep，burp-beep，burp-beep？ ; - Quaker Jake
/ ^^Whatcha doin？ - 同上TIM-MAY !! - 我
Tim Marshall写道：john_liu写道：
我使用MS ACCESS数据库大小为250MB。 dababase
由60个表组成，没有其他对象。无法更改此
数据库中的对象。我想减少数据库的大小
并删除了所有60个表中约50％的记录，但这个数据库的大小仍为250MB。有人可以告诉我为什么以及如何减少它。
如果您使用的是Access 2000或更高版本：
有工具 - >数据库实用程序 - >压缩和修复数据库
当删除
记录时，访问数据库引擎MS Jet不会放弃climed空间。上述过程是必需的。即使没有删除任何记录，上述过程也应该减小大小，因为
数据库会根据所执行的活动而略显膨胀。
被删除的记录是臃肿的唯一来源吗？运行
查询是否也会增加膨胀？也许创建临时查询，运行，然后
删除？
I use a MS ACCESS database with the size of 250MB. The dababase consists of
60 tables and no other objects. The objects in this database can not be
changed. I wanted to reduce the size of database and deleted about 50% of
records in all 60 tables but the size of this database remains 250MB. Could
someone tell me why and how to reduce it.
Thanks
Try:
Tools | Database Utilities | Compact
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"john_liu" <jo******@charter.net> wrote in message
news:lD*******************@fe06.lga...I use a MS ACCESS database with the size of 250MB. The dababase consists of
60 tables and no other objects. The objects in this database can not be
changed. I wanted to reduce the size of database and deleted about 50% of
records in all 60 tables but the size of this database remains 250MB.
Could someone tell me why and how to reduce it.
john_liu wrote:
I use a MS ACCESS database with the size of 250MB. The dababase consists of
60 tables and no other objects. The objects in this database can not be
changed. I wanted to reduce the size of database and deleted about 50% of
records in all 60 tables but the size of this database remains 250MB. Could
someone tell me why and how to reduce it.
If you''re on Access 2000 or greater:
Got to tools->database utilities->compact and repair database
The access database engine, MS Jet, does not surrender climed space when
records are deleted. The above process is required. Even without
deleting any records, the above process should reduce the size as the
database tends to bloat a bit depending on the activities performed.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Tim Marshall wrote:john_liu wrote:I use a MS ACCESS database with the size of 250MB. The dababase
consists of 60 tables and no other objects. The objects in this
database can not be changed. I wanted to reduce the size of database
and deleted about 50% of records in all 60 tables but the size of
this database remains 250MB. Could someone tell me why and how to
reduce it.
If you''re on Access 2000 or greater:
Got to tools->database utilities->compact and repair database
The access database engine, MS Jet, does not surrender climed space when
records are deleted. The above process is required. Even without
deleting any records, the above process should reduce the size as the
database tends to bloat a bit depending on the activities performed.
Are deleted records the only source of bloat? Does the running of
queries add to bloat too? Maybe creating temp queries, running, then
deleting?
这篇关于数据库的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
