Microsoft Access database is uniquely designed for allowing to consistently increase the size, except you compact it. When you remove a record from the database, the space assigned for that record prolongs to be help in reserve by database and it isn’t released for reprocess.
If you do not compact your database at all, it will retain the ‘wasted’ space and carry on to consume extra space to house supplementary data. For instance, if you remove all of the records from an 1MB database and then add 2MB data, your database will be 3MB. The 1MB space of the deleted record could not be used.
In such situations, the database grows in size and can become very large. The large database’s performance can get decreased. It can generally lead to the nightmare of Access database corruption, which is not acceptable at any cost.
To overcome this problem and repair the database, you need to use ‘Compact and Repair’ tool. This utility first compacts the database by eliminating the wasted space and afterwards repairs it to make it accessible again.
The compact reduces physical size of the database by making an accurate duplicate copy of the database while also removing the wasted space created by deleting the records. It is the only way to decrease the database size. It restructures the database records and objects and then stores them in consecutive memory blocks, eradicating the unusable space.
Though, compacting the database is the best idea to remove the unused space of the corrupted database, but sometimes when you attempt ‘Compact and Repair’ on a damaged Access database, it may fail and show the following error message:
“Record(s) cannot be read; no read permission on c:\work\NIF.mdb”
In such situations, you need to repair the database using some third party applications known as Access Recovery software. Access recovery software are the tools which systematically scan the damaged MDB file and repair and restore it in its original state.
Theses software are very easy to use and perform access repair in almost all cases of database corruption. There are several data recovery companies which provide Access recovery software but selecting the best one among them is really important for ensuring absolute Access repair.
Stellar Phoenix Access Recovery software the best ever made and award winning Access repair software which is capable of attending all the MDB corruption cases. This software systematically examines the corrupted database using influential algorithms and extracts all the data from it.
Access Recovery software can repair and restore all the database objects including tables, reports, forms, macros, references, constraints and many similar. You can perform Access recovery using this software for all the file versions of Access including 2000, 2002, 2003 and 2007.