Archive for June, 2010

If you are a developer who uses MS Access database file (MDB), you must know that how frequently the size of MDB file increases. Though, you keep on deleting unnecessary objects, size of the MDB file does not get reduce to the remarkable extent. Increase in the size of MDB file not only affects the performance of MS Access but also increases the chance of damage of the MS Access database file. It becomes very frustrating when you need to wait for a long time to access an object, which can be accessed in just few seconds. The more frustrating thing about MS Access apart from waiting for accessing object is getting an error message prompting that MS Access database file has been damaged.

If the slowing down of MS Access or error messages is not handled immediately then you can come across severe data loss. Once the database file is corrupt, all of the data stored in it becomes inaccessible. Recollecting the data requires significant time and can be very tedious and frustrating. If you take required action then data loss can be prevented. Following steps can be taken to prevent the data loss:

  1. If you are experiencing slow performance of MS Access then you should manually compact the MDB file so that the extra free space available in the file can be removed. When you compact the MDB file then the size of MDB file gets reduced, which ultimately increases the performance of MS Access.

  2. If you are getting error messages then you need to repair the corrupt MDB file using Access Repair Tool, which can be easily found over Internet.

Use the Access Repair tool for repairing the damaged MDB file. The software is available for a free demo so that you can experience the software features. While repairing the damaged MDB file the software maintains data consistency and integrity so that you can use the recovered data as is. The Access Repair tool supports MS Access 2003, Access 2000, Access 97, and Access 95.

MS Access database stores essential data and corruption in it may leave you in a very frustrating situation. Since prevention is always better than cure, this blog will discuss things that can be done for preventing corruption in Access database. Here are some points that can help you to prevent corruption: While performing database write process, it is must to avoid power failure or interrupted power supply. If during the write process power loss occurs, the database may go in a suspect state. It is essential to take care of network connections, so that any process may not hang in between due to improper network connectivity. As improper termination of Microsoft Jet connections may cause damage or corruption in Access database thus avoid doing so. Close all DAO objects and ADO objects before programming. Do not ignore frequent as well as unusual database errors, as they may cause abrupt termination of database. If you notice any error, then first of all resolve it to avoid fatal consequences like database damage or corruption. Make a habit of compacting the database after certain time period. Frequent compacting of database can help you to prevent corruption to a great extent. Always remember that running a large number of open/close operations in a loop can throw your Access database in trouble, so avoid it By keeping these things in mind, you can prevent you MS Access database from getting corrupt or damaged. However, if corruption occurs even after taking care of these things, go for a reliable and efficient Access repair tool.