MSAccess file format woes

[Kri5]

One mdb file with one table, 3 columns and containing approx 15 records. Size is 88kb. Deleted ALL records, no other changes, and...guess what? Size *grows* to 128Kb...:confused:

[Don Miguel]

Probably, this is related to possibility to restore deleted rows. So, even you have no data in the table, the "log" maintained internally by databse recorded your records and you will be able to restore them.

[Pavel Klocek]

Use "Compress and repair" function in Access and it should shrink. The Jet db engine only ads sectors while manipulating the db file. Pavel Sonork 100.15206

[C0d3_P03t]

There is an option in access, compact and repair, do it and u'll see a better file size :) Regards, Luke

[S Douglas]

Kri5 wrote: guess what? Size *grows* to 128Kb... Thats common, to reduce the size of the file, you need to compact and repair the database. ------------------------------- DEBUGGING : Removing the needles from the haystack.

[Kri5]

Yes that's what i thought initially: the engine doesn't really delete the records, but adds extra info to mark them as deleted, hence the increase in size.