Steve
Reputation: 552
Access conversion from .mdb to .accdb shrinks file. Why?
when i converted the MS Access 97 .mdb file to MS Access 2007 .accdb file, the file size was reduced.
Originally, .mdb file size was 15 mb. After conversion to .accdb, its size became 8.52 mb. Why so.?
Upvotes: 0
Views: 449
Answers (1)
PaulFrancis
Reputation: 5819
When you Save and Publish to a different version a routine Compact and Repair is performed. This will clean up the Database of any available garbage space, compile/compact codes. Thus you get some extra space.
Upvotes: 2
Related Questions
- How to reduce ms access database file size(*.accdb) after deleting data in it (MS Office 2007)
- Growing MS Access File Size problem
- Access MDB: do access MDB files have an upper size limit?
- How to reduce growing size of an access file?
- Database created by ADO (from VBA) reduces file size after opening in MS Access. Why?
- Size of access database increasing
- MS - Access 2007 database operations and MDB file size
- Wouldn't MS Access(.mdb) file size reduce after deleting the content of database?
- Access 2010 dislikes my .mdb file
- Why should I care about compacting an MS Access .mdb file?