Over time, your Access databases may not only grow in size but there may also be a chance that they get corrupted to some extent. Microsoft Access provides a Compact and Repair Utility to deal with this problem.
As you keep using Microsoft Access to build and operate your databases, the MDB files used to store Access data will grow in size. After a certain point, Access is not able to manage large MDB files very efficiently. Further, as you keep accessing these databases and modifying them, there is a fair chance that the MDB files may become corrupted. It is precisely to avoid these problems that Access has provided the Compact and Repair Utility. Compacting will allow the files to stay within manageable limits and the Repair feature will allow you to quickly repair damaged MDB files. If this utility proves unsuccessful in restoring the data from your MDB files, you could try advanced applications to repair MDB files.
The Compact utility essentially makes use of the space that is created due to object and record deletions - space that typically stays unused. It creates a new destination database and then actually copies each object from the old database into the new database, making full use of all space. You could give this new database the same name as the old one but in that case the compact process actually creates a temporary database, moves all the objects into it, deletes the original database and then gives the same name to the temporary database.
The Repair process tries to repair a damaged database by repairing the objects contained in the database such as tables, indexes and queries. Unfortunately, it is not able to repair damaged macros, modules, forms or reports. It is therefore highly advisable that you take backups of your database files as often and as regularly as you can so that even if the original database file becomes corrupted beyond repair, you can restore data from the backup copy.
No comments:
Post a Comment