'Access Recovery | Recover Access | MDB Recovery' Blog RSS Feed

Access Database corruption Post Software Conflicts

davidwillium — Sat, 05 Dec 2009 02:31:32 -0700

A program that is installed in your system to interact with host application and perform a specific function is known as a Plug-in, Snap-in, or Add-in. Microsoft Access users use this program to add custom commands and specialized features to save and maintain their database effectively. While installing a plug-in provides lots of benefits, incorrect or incomplete installation can also result into corruption of MS Access database. In such situations, you receive an error message that stops you from accessing the records stored in the database. For systematic access of your database records, a standard way is to restore the records from an updated backup. But, in absence of an updated backup or backup falling short to restore the required data, you will need to opt for an advanced third-party Access Recovery software.

To illustrate this, consider an example where you install a new third party plug-in to improve the performance of MS Access. However, after installing the plug-in, when you attempt to view the records saved in the database, they become inaccessible. Furthermore you also encounter an error message stating the cause for inaccessibility of database records.

Cause:

Few main reasons for the inaccessibility of database records are discussed below:

Installing a faulty plug-in.
Improper installation of a plug-in.
Incomplete installation of a plug-in

Resolution:

To resolve the above error message and to access the database records, you will need to repair the corrupted database using the inbuilt repair utility known as “Compact and Repair”. While the repair utility completely repairs your corrupted database in most of the situations, it fails to repair under below two situations:
Access database is too large
Access database is badly corrupted or damaged

If your database remains corrupted due to any of the above situations, then you will need to use a powerful Access Database Recovery application to repair your database. Such utilities use high end scanning mechanisms to repair your database after any kind of logical crash. These Access Database Recovery tools are completely non-destructive in nature and ensure safe recovery of database components.

Module Corruption in MS Access database

davidwillium — Thu, 26 Nov 2009 22:33:42 -0700

Modules in Microsoft Access are the storage components that store all the code required to perform different functions in your database. These Modules are primarily created by the programmers for making their routine tasks re-usable. In most cases, these MS Access modules are associated with reports and forms. Although compiling the code saved in Modules is a trouble-free task, corruption in database might occur when you attempt to edit the code while the Module is running. In such situations, the data stored in the database becomes inaccessible. To surmount the dangers created due to Access database corruption, a standard way is to restore the data from an updated backup. However, if the backup is corrupted or backup falls short to restore the required data, then you will need to use an advanced Access Database Recovery software to repair the corrupted database.

For example, you created a module and while compiling (in break mode) it, you changed its code. The compilation process halts and you encounter an error message. The error message indicates MS Access database corruption.

Cause:

The error message occurs because the MS Access gets confused between the below categories of your code:

Text-version of the code
Text-version of the temporary copy
Actual version of the code that is running

Note: Please avoid changing the Module code while it is running.

Resolution:

To resolve MS Access database corruption, compact and repair your database using below steps:

Choose “Database Utilities” on the Tools menu. Click on Compact and Repair Database option.
Choose the database file in the ‘Database to Compact From’ dialog box that you want to repair. Click on Compact.
Select a new folder destination for the new file in the ‘Compact Database Into’ dialog box.
Assign a unique, valid, and new name for the database file. Finally, click on Save.

The above steps repair your database in most situations. However, if database corruption persists and you are not able to access the database records, then you will need to search for powerful Access Repair application. These recover access database tools are competent enough to resolve corruption and provide accessibility to all your Access database objects.