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...
相关阅读
请问数据表里筛选变量名的写法Help? what does "--" mean in Teradata?MSSQL 2005, Database mail不工作了我靠，oracle考试竟然涨价了什么地方有SQL习题集？Access to a path is denied across domains我应该装那一款mySQL啊？postgres下如何得到响应时间请帮忙在PL/SQL里面执行下面的计算，一个笔记软件破解用的新手请教：为什么这个Query不work请推荐SQL教科书请教一个数据输入的问题中部一公司在招SQL DBA，有人感兴趣吗？发现好像讨论OLAP, Cube, SSAS的不多啊University of California, Merced, Ph.D. positions availableOracle SQL Developer Data Modeler is Now FreeOCP 怎样的path 比较好，SQL中NOT EXIST和NOT IN有什么区别?要回国腐败了.Job Openings: Data Warehouse Architect/ETL/Business Objects (转载)
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。