b******d
发帖数: 115 | 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... | v*******r
发帖数: 5 | 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...
| v*******r
发帖数: 5 | 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!
| o**y
发帖数: 1466 | 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...
|
|
