MS Access database corruption – causes and fixes

Causes:

Hardware failure issue : It is the most common reason for database corruption even, I can say in 80-90% cases. It affects the database integrity which is related to networking and hard-drive.

Software clashes: sometime the 3rd party plug-ins and programs can be the reasons of MS Access database corruption. This kind of applications has their own rights and programming behaviour and they also run in the same memory space as the database.

 Access of multi user: MS access database works on JET database engine, which is a file-based system. When multi-users work on the same time then jet database engine uses lock file (.ldb file) to manage the synchronization between them. By doing this, the speed of the jet database engine becomes slow. The session disconnects due to time-out failure.

Fixes

Always take a backup: The necessary thing which can help you to get your database back is, it’s backup. Always take the backup of your database according to your schedule. If you do not have the database backup and suddenly corruption occurs then, take the backup immediately. This is the first thing which you should do and if you are a DBA then it is your duty.

In case, if you have the previous backup of your database then you can get back your database structure because corruption is the part of Access database structure rather than jet database format.

Delete the .LDB file: This file is used to synchronise multi-user file operation therefore, it doesn’t need to repair MS Access database. If a user won’t delete this file, then it is high chances that user or program will be logged into the database. With this, you should close all the open instances of MS Access database.

Compact & Repair: This command prevents your database by following problems and file growing larger is one of them. Access database file becomes larger after every operation and this command makes the file smaller by removing the unused space from it.

Note: It doesn’t compress the database.

If the database file is in the shared network and multi-users directly working on it then there is a small risk of the corruption. It will become riskier when users edit the data in the memo field.

Microsoft JET Compact utility: Jet.Comp.exe is a utility which is developed by Microsoft to correct minor corruption of the database. It is the most successful built-in feature of MS Access to repair Database corruption. You can read more about JET compact utility here: http://support.microsoft.com/kb/273956

Decompile the MS Access VBA Code: To decompile the VBA code, run the following command from the command line.
C:\Program Files\Microsoft Office\Office\MsAccess.exe /decompile C:\DatabasePath\FileName.mdb
Note: it is an example, please change them path according to your system.

 

Third Party Tool: Stellar Repair for Access is able to repair corrupt .mdb and .accdb files. It is 100% secure software for MS Access database repair. It works on MS Access 2016,  2013, 2010, 2007 and other older versions

Conclusion: These are the few points which you should remember. The database corruption can occur by a small mistake so, always take care of it.

»»  Read More...

How to resolve Access Database Error: 'An error occurred while loading Form_FormName'

Have you ever suffer with this error message: 'An error occurred while loading Form_FormName'. I had faced this issue last night. Here is full scenario: 

Real Life Scenario: When I was trying to open the database, the message pop up:

"An error occurred while opening 'form'. 

After that it asked me 'Do you want to continue loading the project?, Then I clicked on 'Yes'. After that I got this error message: 

"The form name 'form_old' is misspelled or refers to a form that doesn't exist." 

When I clicked OK, I got the same message total of 3 times & Then finally the database got open. If you are also facing this problem then use following steps that I used to fix the issue:

Solution: This error means that your database is partially got corrupted. This error occurs when you tried to convert your database from one version to another. To resolve this issue, Decompile the copy of your database: 

1.First make a copy of the mdb file when the Access database is not running.

2.Compact your database:

In Access 2010, Compact and Repair Database on the Database Tools ribbon.
In Access 2007, click Office Button (top left) | Manage | Compact.
In Access 95 - 2003, Tools | Database Utilities | Compact.

3.After that Close your database & Open command prompt, and type this in command prompt and include the quotes:

 "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\My Documents\Database.mdb"

4.Compact again your database.

5.Try the conversion again.

This is the solution which I used to fix my issue. But one of my friends told me that this step got failed to resolve this error message. He suggested me to try Third Party Access Recovery Tool. Then Again I tried Third party tool in the same scenario. The tool successfully repaired my database which was partially got corrupted. Both solutions worked well in my scenario. Good Luck for you to fix your issue by above methods!! 

If you have any other solutions, please share in comment. 

»»  Read More...

How to fix Error: “Microsoft Office has detected that this database is in inconsistent state”

Yesterday When I was working on my Access database, suddenly the computer power plug got loose. After that, when I was trying to open the database, I got following error message: 

When I was clicking on 'OK' button, a second error message box appeared, which states, 

"The database <database path> can't be repaired or isn't a Microsoft Access database file.”

Why these errors occur? I found some causes & solutions of the error. 

Cause: This is the Access 2007 error message which indicates that MDB file got corrupted.

PS: When you are going to use any recovery step, Use copy of your database. Do not perform any step on original database.  

Methods that I used:

1. Run 'Compact & Repair' utility to repair your corrupt access database. 
Microsoft Office button >>From the Office menu, choose "Manage", then "Compact and Repair Database”

2.  If your database is not opening then you can also run a compact/repair without opening the database by using a command line switch.

Create a shortcut and for the target use: "c:\program files\office
11\msaccess.exe" "c:\pathtodatabase\database.mdb" /repair

you’ll have to replace the two parts in quotes with the actual path to your Access executable and database. 

3.  Unfortunately, there are some access database corruption errors that cannot be fixed by compact & repair utility.  In this case, create a blank database, and try to import one table into the database. If that works, then you can import all the tables into that new database.

4.  If all above steps got failed then you should use third party access repair software to repair corrupt access database. These software work on all access database corruption errors even compact & repair get failed to repair database. 

Hope above steps will help you to resolve this error “Microsoft Office has detected that this database is in inconsistent state”!!

»»  Read More...

4 Easy Tips to Repair Corrupt Access Database

Access Database corruption situation can occur at any time, you can get more fostered if you did not find the best solution to repair Access Database. With a little bit research, you might get better solution to repair the database or at least recover the data. 

Note: Before you take any action it’s advisable take backup copy of your database!!! Apply all the recovery steps on the copy of the database. 

Here are some important tips to successfully repair your corrupt database: 

Compact & Repair: If any corruption error get occurs while you are working on your Access database than you should first use compact and repair utility to repair corrupt access database. 

• In Access 2010, click Compact and Repair Database on the Database Tools ribbon.
• In Access 2007, click the Office button (top left), then Manage.
• In Access 95 – 2003, choose Database Utilities from the Tools menu.

Decompile Your Database: Compact & Repair utility does not restore forms, reports modules and macros. If the form & report get corrupted then you should decompile your database. 

Windows>>Start>>Run command line>>type: msaccess.exe /decompile

where msaccess.exe includes the complete path. For example, for Access 2010:

C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE /decompile

First open your database that you want to decompile:

1.Open up any module. Compile it via Debug, Compile.., then File, Save.

2.Go back to the database and Compact it.  

Create a new database & import everything into it: 

When all above steps get failed to repair damage access database then, we can import the contents of that file into a new database. To import an existing database file we first need to create a new blank database.

• File menu>>select New>>choose database. 
• From the File menu>>choose Get External Data>>Import>>select the original database file. 
• When the file is opened, click the Select All button on each of the tabs in the Import Objects dialog box. 
• These steps will help you to import all of the Tables, Queries, Forms, etc. from the original database into the new database.

If access database get stopped during the import process, it means that the process hit by a damaged database object. In this case, you have to import database objects in that group one-by-one. Access database does not allow you to import damage objects into a new database, so in such condition you need to re-create that objects.

Once the process completed then you should copy all the objects from the original database in a new database and you are ready to use the new database.

As a conclusion we can say: 

There can be numerous access database corruption errors which may not be resolved just applying above methods. If the error still unresolved then we can also try third party access database recovery software to repair corrupt Access database & files. I hope this way we can easily repair corrupt access database.

»»  Read More...

Access Database get corrupted: An Important Information for every Single User

Access Database: Access is database software to store your valuable data in a organize way. You can create tables that help to organize your data. You can also create forms to input the data into the tables and then you can create reports that help to print selected info from the tables.

It is also possible that Access database get corrupted due to any reason then you need to be aware save database from corruption. Here I am sharing few answers which you may have faced Access database corrupted. 

What has happened? 

Between 19 Feb and 20 Feb, I have realized that there had been an "unknown error" displaying in the Access database. The database automatically shut down and my mind got stuck.

How has this happened?

I have asked many access users and all said they will reply to answer as soon as possible. Indeed, I have written mails to many access experts demanding an explanation of this error as well solution. It seems, though, that there has been severe corruption in the mdb file infrastructure. At the end, I got many mails with same message saying your database got corrupt!! They also suggested me to post my issue on numerous access help forum sites that provide solutions related to access database corruption & errors. 

What should I do about my database corruption?

While your database is getting shut down, there's nothing you can do with your database not even run compact & repair command So first you should immediately copy your database in to different drive & run access database recovery software on it. This software recovers database in most cases of database corruption without harm your original database.

What other precautions should I take?

Do whatever you want to do with your database but only on copy of your database. Don't perform any experiment on original corrupt file. 

Before performing any action take a backup of your database.

Find the exact cause of database corruption, it will help you to take better solution in database corruption case.

How will I know if my database has been corrupted?

A Database Corruption: There are many cases when database corruptions are hidden and are found only by testing & applying unique steps. There is also a severe database corruption case in which you are not able to be connected to the database. In some cases the database shows strange errors or when it is not possible to restore the database from backup copy also. These are some common database corruption symptoms.

Can I safe my database in future from such corruption:

It’s all depend on your usage of your database means how well you use your database. Here are some tips to prevent your access database form corruption:

• A backup is more than your data and compact regularly.
• Do not copy access file if your database is open.
• Don't Shutdown your system without closing Access database.
• Never allow users to modify the same file at the same time

These are some general terms, The database corruption is an issue facing every users in your life. There is always a question mark whether this database application can ever be 100% corruption free.

»»  Read More...

Is Access Database Recovery Software Safe to Use?

It is one of the most common question being asked by users i.e. ‘Is it safe to use Access Recovery Software for corrupt Access file & object recovery’? I strongly recommended “YES” but some points are applicable. Users avoid some points when choosing access recovery software which are most consideration points in to account when working or choosing these tools. Users choose access recovery software as per their knowledge. I was surprised to see where 65 percent users reported that they could not recovered their important data and 35 percent reported that they are satisfied & recovered their data successfully. Here's another eye-opener. WHY 65 percent users were not satisfied with Access Database Recovery software? That is why it is very important to do full market research before choosing any software. 

What are the points that 35 percent users used, here are the list of that points:

Advanced Features CHECK: Each Access recovery software offers wide range of advanced features, such as support of access database files, ability to recover from all versions of Access database and so on. First try to analyze a feature set for each of them and choose the one that suits you best. Be careful, though, as some software offers a lot of useless and redundant features that are useless & will more distract than help.

User-friendly INTERFACE: Choose the software which have the simplest user interface, so that you don't have to waste your precious time on studying it. Look out for software that elegantly combines an easy-to-use interface with extensive set of useful functions. This may be crucial for downloading any database recovery software.

Recover Data PERFECTLY: Well, it's obvious that a database recovery tool should first of all recover data perfectly after that any other thing. It’s a good idea to first download a trial version which is free of cost & finds your lost file. If it fails to recover database, then it means something wrong may be not only with the database but also with the software.

Customer support OPTIONS: When choosing the database recovery software, also pay attention to its customer support options. If the support section has many forms like e-mail, phone, online chat etc then it invokes a feeling of trust and safety. You can call mail to customer support before purchasing the software & collect all the details about the software. OR you can also send your corruption case by mail & can get idea that the case can be repairable or not. 

On the positive side, a few users thought that this whole points has been seamless — even though other one find it will take a long time to figure out. But in my opinion, if you are consider whole points it will not take more than 15 minutes. So consider each & every mentioning point before using any database recovery software. 

»»  Read More...

5 ways to say Goodbye to Access database corruption

Most Access database users complained that Access is susceptible to corruption. Here are some ways to help you to protect your database from corruption. The ways are understandable and useful which I explain here not only for technical users, but also novice user can easily use it. These ways can help you in future as well. 

Never forget to take “Backup”!!

It is mandatory to schedule and maintain a regular backup of access database on safe location in the drive. Never store it on the same hard drive with your database because if something went wrong with that drive, you’ll lose data as well as backup copy. You can also use backup software to perform backup process. But remember some backup software starts backup process even if they’re open. These process only increases the possibilities of corruption, so first close your database before you perform backup process.

Encrypt only when required!!

At writing time every page is encrypted and decrypted at load time. If your database gets corrupted then it is very costly & difficult to recover encrypted data. So use only when it is more required.

Schedule regular maintenance of your database!!

Every application should have some basic maintenance built in. Schedule regular maintenance within your database. You can set it weekly, monthly.  Through automatic backup and clean shutdown detection, you can maintain your database.

Compact Regularly!!

Regularly compact your access database. Compacting always improves database performance. The Compact and Repair Database option is available in the Tools group on the Database Tools tab. Set this option to database so that at the time of closing database will compact automatically. Be sure you should back up your database before compacting.

Don't use mismatched Versions of the Jet Database Engine!!

All access database version supports different Jet database engine versions. If you try to run different versions of the Jet Database Engine in your environment, it can also corrupt your Access database. 

Last but NOT least:

Test to ensure following points that mentioned in the article. If all things in your database appear good & backup copy is also fine then you just need to check you are using right Jet Database Engine or not. Use compact repair utility to make sure about the maintenance of database. If it completes, then the corruption issue get resolved. But it may be possible that database get failed or at least appear to be fail in the initial step. You may have received corruption warning message it means there is still something wrong with database. To overcome this problem you can use Access Database Recovery Software. This software easily recover corrupt database and save it on your defined location.

Please feel free to write your comment if you have any doubt.

»»  Read More...

Why “This database is in an unexpected state” Error Message Pop Up & Solution of the Error

“This database is in an unexpected state; Microsoft Access can't open it...”

If you find this error message on your PC screen when you try to open MS Access database then it is impossible to open access database. But if you will follow some steps one by one the impossible word can be “Possible”. So here are the steps which you should follow to solve this error message:

First we should know “WHY THIS ERROR OCCURS”?


 

  

Possible Causes:

• This error message pops up when you are trying to convert Access database from a prior version of Microsoft Access by using the DOA compact database method. This has left the access database in an unconverted state.
• Access Database has been severely corrupted.  

 Choosing the Best Solution:



 


Choose the best solution as per your requirement:
 

• If you have a copy of the access database in its original format, Use Convert Database command on the Tools menu (Database Utilities submenu) to convert from a prior version of Microsoft Access instead of DAO Compact Database method.
• If the original database is not available, create a new database and import your tables and queries to preserve your data. But remember that your other database objects can't be recovered.
• If you want to recover all objects- In this case you should use Jet Compact Repair utility to repair your access database.
• If above utility is not able to repair your database because this utility has its own limitation then you can use Access Repair third party tool. Stellar Phoenix Access Recovery Software recovers access database after all access database corruption error.

You can choose any one step or if you don't know about what step you should choose to solve the problem, you can use all four steps one by one. By following these steps you will definitely solve this issue & able to access your database successfully.

»»  Read More...

Encountered Error After Importing Contents of Form? Here is The Solution!

Through the Microsoft Access forms, a user can insert and modify the records into the database more easily and quickly. These forms have user-friendly graphical interface which can easily be used by anyone who is familiar with the basics computer techniques. However, sometimes a user may encounter some error messages relating to MS Access form corruption. The corruption in MS Access form occurs due to virus attack, application malfunctioning, importing the form by using Microsoft Access 2000, etc and in such situations the MS Access database form becomes inaccessible. But, to restore the form, a user can always use latest backup but in the unavailability of proper backup, third-party Access recovery tool can do the needful.

 

Let us discuss this through a practical example wherein a user creates a new form named as ‘Student’ by copying all the controls from the previous form. However, when the user attempts to view the contents of this new form encounters the below mentioned error message:

 

“This action will reset the current code in break mode.
Do you want to stop running code?
To halt the execution of the program so the Module window can be closed, select Yes.
To leave the code in the current state, select No.”

 

When the user selects ‘Yes’ then he/she encounters the same error message. However, upon selecting ‘No’, the system hangs and the form becomes inaccessible.

Cause:

The above mentioned error message is caused when MS Access 2000 and version 6.3.91.8 of the Vbe6.dll files are installed on the computer system and any of the below mentioned conditions are true:

• The user has copied and pasted the form which included the modules into a new MS Access 2000 database using MS Access 2000.
• The user has imported the form/s which have standalone module into a new MS Access 2000 database using MS Access 2000.

 

Resolution:

 

The ‘Compact and Repair’ utility of MS Access database can solve the issue but if this utility fails then the user needs to recreate the form and perform Access repair to recover all the components presented in this (Student) form. To do so he/she needs to take the help of third-party Access recovery software. These software can repair severely damaged database files and recover records or objects in a new Access database file.

 

One of the highly recommended and efficient Access database recovery software is Stellar Phoenix Access Recovery Software. This powerful Access recovery software recovers corrupt Access database files created in MS Access 2010, 2007, 2003, 2002, and 2000. The software allows the user to see the preview of the repairable database objects and is compatible with Windows 7, Vista, Server 2003, XP, and 2000.
 

»»  Read More...

How to Resolve “Action was cancelled” Error of MS Access and Recovering Your Valuable Data

To enhance the functionality of our Microsoft Access database and add advance features to it, we sometimes convert it to a new or higher version. Though the conversion of MS Access database is a common task but at times unsystematic or improper conversion to a new version may create inaccessibility of Access database and thus, we end up losing our valuable data. In the situation of data loss (or data inaccessibility), we always have an option of backup to restore our data. However, in the absence of proper backup or if the backup also fails to recover the data then we can opt for third-party Access recovery software.

 

Consider a practical scenario, wherein you convert your MS Access 2002 to MS Access 2003. After the conversion when you tried to open a report (which was working fine before conversion), you encounter the following error message:

 

“vopen report”

 

In addition, you encounter another error message as:

                                          
“action was cancelled”  

Soon after encountering this error message, the report which you were trying to open becomes inaccessible. The situation becomes worse when you encounter the same error message while attempting to open any report saved on this converted Access database.

 

Cause:

 

The main cause of encountering this unexpected error message every time while opening any report is incompatibility of reports with new version of MS Access database.









The best way to troubleshoot this error is to convert your database back to older version. However, if conversion to the previous state is not possible then the only way to access all the reports is to go for third-party Access database recovery software. These software use powerful scanning method to provide absolute recovery of your valuable data and recover database files which include .accdb and .mdb file extensions.

One of the highly appreciated software for Access repair is Stellar Phoenix Access Data Recovery Software. The efficient software has highly interactive user interface and simple recovery steps which does not require any experience of Access database recovery. The software supports MS Access 2010, 2007, 2003, 2002, and 2000 and is compatible with Windows 7, Vista, Server2003, XP, and 2000.

»»  Read More...

Causes and consequences of VBA Project corruption in MS Access and tips to perform Access recovery

Visual Basic for Applications (or VBA) is based on Visual Basic 6 (an event-driven programming language by Microsoft). You can use VBA to create user-defined functions for automating several processes and performing other low-level functionality. It allows you to control user interface features, such as menus, tool bars, etc. and modify user forms or dialog boxes. It provides additional flexibility to the database or the host application. However, sometimes corruption occurs in the VBA code and makes all database objects inaccessible. To overcome this problem, you need to go for Access recovery through a reliable third-party utility.    

    

When you attempt to open the Visual Basic Editor in your MS Access database, you may come across any of the below given error messages:

 

“The module name 'module name' is misspelled or refers to a module that doesn't exist.
If the invalid module name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and type the correct module name.”  

                                                   Or

 

The above errors occur when there is some corruption in the database's  Visual Basic for Applications project. 

As a consequence, all your valuable database objects like forms, reports, modules, etc. become inaccessible. In such circumstances, you may use a recent/updated backup to restore your database. However, if the backup is unavailable, you should follow the below mentioned resolution steps.  

You need to follow the procedure given below to perform Access database recovery: 

• Initially, create a blank Access database.
• Open the corrupt database. Select 'Objects' and then tables.
• Right-click on the very first table and select 'Export'.
• You will see an 'Export to' dialog box on your screen. Here, provide the new database name and click 'OK'.
• Repeat the same procedure for every database object.   

If the problem still persists, you should take help of an Access repair tool. These third-party tools are proficient in repairing corrupt Access databases and restoring vital database objects averting every risk of potential data loss. They can easily restore tables, forms, modules, macros, reports etc. Furthermore, they are compatible with Windows 7, Vista, Server 2003, XP, and 2000.

»»  Read More...

Resolve “Invalid Argument” error in MS Access

This error message is signify that user cannot open MS Access database to perform any activity because MS Access database is fail. It can happen even when anything thing goes awry with database that leads to a database inaccessible. The MS Access database get inaccessible due to most of the reasons such as access database error, virus attack, sudden system shutdown, hardware failure, software failure & many more. Error messages “Invalid arguments” comes due to access database get failed.

Find some conditions in which Invalid argument error arises: 

1. When user import, copy, or append data to a table in MS Access
2. When user try to import data in a large access database file (mdb or accdb)
3. Corrupt Records in a Microsoft Access MDB

Due to these error messages user may not be able to access database. I will explain all the conditions step by step:

1) If error occurs due to first condition then use can obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) to resolve this error.

2) If error occurs due to second condition then user can resolve this error by splitting the Access database file.

Steps to Split Access Database:

1. Start Access Database.
2. Open the problem Access database file.
3. Go to Tools menu, point to Database utilities in the Database window, and then click Database Splitter button.
4. In the Database Splitter dialog box, click on Split Database button.
5. In the Create Back-end Database dialog box, type a name for the back-end Access database file in the File name box, and then click on Split button.
6. Now Click OK button.

3) If error occurs due to third condition then it is advisable to use an inbuilt repair utility “Compact and Repair”. In some conditions “Compact and Repair” utility won't work because of its own limitation then user can use Access Database Recovery Software.

»»  Read More...

How to repair access file & valuable data from the corrupt access database safely

Microsoft Access is a desktop database application and is designed to run from a single computer system. Unlike Server database applications, which are installed at a server system and accessed from a remote computer, MS Access database solely hosts on a single system. The application was indeed developed to full fill the need of small scale enterprises and the home users. Access comes with the Microsoft Office suite and can be installed like any other software package. As a product of Microsoft, though it is almost flawless, there are occasions, in which Access users face loss/inaccessibility of valuable data following Access database corruption. For all such instances, the Access database repair utilities can be immensely helpful.


Using the MS Access database, you can create Tables, Forms, Reports etc. Small organizations use Access to keep record of their sales cum purchase information. People use the application to get their sales reports by grouping, arranging various informations from the invoices, product table, customer table etc. With many simple and easy-to-use features, Access is widely used for analyzing daily, weekly or monthly business reports by many.


With many important data in the Access files, sometimes, it gets corrupted leaving all your precious data either lost or inaccessible. Below written are some of the commonly faced reasons behind Access corruption:

• Contradictory third-party plug-ins
• Malfunctioning of Microsoft Office
• Operating system crash
• Malware/Virus infection
• Simultaneous alteration of the MS Access components
• Corruption to the file system of the computer

One interesting finding about data loss is that data is never lost form the media till the same is overwritten by some other data. Therefore, under any instance of database corruption, if you can prevent the troubled database from further damage, it cane be definitely recovered back.

However, in any case of Access corruption, if you can sense the reason to be related with other than the Access database itself, you must first try to resolve the same. Secondly, you have always the safest option to get the data back by restoring it from the recent backup.

In case, you do not have any backup available, you need to choose and run any good third party Access repair utility to do the job.

The Access Recovery Software is an wonderful utility to repair Access file and recover your troubled database under any instance of corruption. These third party software is read-only in its operations and very helpful in getting the data back.

»»  Read More...

Access Database corruption Error "AOIndex is not an index in this table"

Have you got this error message : "AOIndex is not an index in this table"

Here I am sharing my personal experience on this error message. After replicating the access database , I stores it in the same network folder. Now I am not able to open access database & got error message:

"AOIndex is not an index in this table"

It make my access database unusable !!

Why this error occurs: This error have multiple reasons:

• Faulty entries in the MSysAccessObjects table.
• Corruption in the MSysAccessObjects table.
• Invalid indexes error.
• MS Access database corruption.

Solution:

• If you have non corrupted backup copy of access database then try to export all the forms.
• Make a copy and try the free Microsoft Jet Compact Utility program. The Jet Compact Utility program has fixed invalid index errors.
• Use Access compact/repair utility. This utility rebuilds the indexes.
• Try third party access recovery software to repair corrupt access database indexes.

In which conditions you can use all above four solutions:

• You should have backup to apply this solution.
• Jet Compact Utility program won't work on severely corrupt access database.
• Compact/repair utility has some limitations. If compact/repair utility discovers data that violates the indexes then it drops the index. The table still has all the same data, but the index is gone. If you have relationships to other tables that depend on this index, the repair process will drop those relationships. SO in this case it is not work properly. To fix this situation, you need to identify the records that violate the index. To find the problem records, you have to use some query. So in this case it is very hactic procedure & not easily understand by everyone.
• Third party access database recovery software recovers corrupt access database in most possible cause of corruption. First use demo version of the software to check how much corrupt access data is recovered by the software after that purchase it.

»»  Read More...