logo
Redian新闻
>未名空间
>Database - 数据库
>
Access database size
avatar
Access database size# Database - 数据库
b*d
1 楼
i created a new database using Access2000, there is one table which
i populated 14000 rows. the .mdb file size is about 14MB. but after i
deleted all the rows in that table, the .mdb file size didn't change.
how come? i even tried closing the database. does that mean the .mdb
file will always be allocated this much space?
thanks...
avatar
v*r
2 楼
even you deleted all the rows,
the physical size still exists,
all the rows become null now,
the null still over there!

【在 b******d 的大作中提到】
: i created a new database using Access2000, there is one table which
: i populated 14000 rows. the .mdb file size is about 14MB. but after i
: deleted all the rows in that table, the .mdb file size didn't change.
: how come? i even tried closing the database. does that mean the .mdb
: file will always be allocated this much space?
: thanks...
avatar
v*r
3 楼
you can try to delete that table ya

【在 v*******r 的大作中提到】
: even you deleted all the rows,
: the physical size still exists,
: all the rows become null now,
: the null still over there!
avatar
o*y
4 楼
Just compact your database
Menu:
Tools/Database Utilities/Compact and Repair

【在 b******d 的大作中提到】
: i created a new database using Access2000, there is one table which
: i populated 14000 rows. the .mdb file size is about 14MB. but after i
: deleted all the rows in that table, the .mdb file size didn't change.
: how come? i even tried closing the database. does that mean the .mdb
: file will always be allocated this much space?
: thanks...
相关阅读
版主，你是不是收了老土的钱？？？ 你为什么删了我的帖子？请问洛杉矶地区sql developer mid to senior level薪水Re: 安心家庭厨房本周六开始为您送饭 (转载)partition 表内推一个DB Engineer职位，3＋年经验新人菜鸟请教 cognos vs SSIS【工作机会】SQL DBA先把CCC那种培训班的水平提高了再说转Oracle DBA，求建议求助（急）：MySQL不能启动！！问一个query谁知道Azure开个VM为什么没有中国data center选项？ (转载)MSBI 2012 优秀的 SSRS class Health Care ReportingSQL fast search in a 10 million records table (转载)如何根据FK， 找到想链接的另外一个Table， 谢谢怎么找工作啊？大家觉得PL／SQL对做JAVA其实半明应该改为 Database and Data Warehouseit转行做finance 今天被it气晕了DB2 Stored Procedure Error Handler
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。