MS Access 97
mdb File | Initial Size | Final Size |
---|---|---|
Contacts.mdb | 1,236,992 | 258,048 |
DeliveryOrders.mdb | 2,103,296 | 358,400 |
Items.mdb | 8,992,768 | 2,156,544 |
MainLibrary.mdb | 1,157,120 | 196,608 |
By watching as MS Access compacted a file on a floppy, it appears that Access copies the mdb file to a second file, deletes the original file, and then re-names the new file. (For files on the hard drive, Access is too fast to see the temporary file.)
Author: Robert Clemenzi - clemenzi@cpcug.org