In the databases, referential integrity is termed as the set of rules that ensures that you cannot delete or move a record in a table if a matching record is present in another table. It is a very useful feature that makes sure that there is no redundancy in the database. However, at times Access behaves in an inconsistent manner because of the referential integrity enforced upon itself by a database table. Such scenarios can lead to corruption in the database. Other reasons for database corruption could be virus infections, power outages, concurrent modifications from multiple users, etc. You should use in-house methods to resolve the problem. At times, you may not be able to repair the corrupted database yourself. In such cases, you should use a third-party Access database recovery software to perform recover Access database.
Consider a scenario wherein you have MS Access 2000 database. From this database, you try to export a table to another database but you fail to do so. An error message is displayed, that is:
“The Microsoft Jet Database Engine could not find the Object ". Make sure the object exists and that you spelled its name correctly.”
When you click OK on the error message, then the following error message is displayed:
“An error occurred trying to export the data from table 'tablename'. The data was not exported.”
Cause:
The root cause of this erroneous situation is that the table that you want to export contains a self-join and Memo field. Moreover, you have imposed referential integrity on the table.
Resolution:
- To resolve this error, you should perform the following steps:
- Convert all the Memo fields in the table to Text fields, OR
- Move all the Memo fields to another table, and then
- Implement a 1:1 relationship between the tables to remove the referential integrity.
The problem would be resolved by using the mentioned steps. Now, try to export the table. It should be working fine now. However, if the problem is persisting then you should use a third-party MDB recovery software to recover Access database. Such read-only tools are able to extract the corrupted data from the Access file without overwriting the original file.
An Access database can becomes inaccessible due to failure in saving process, sudden system shutdown, virus, etc. I read a solution to recover MDB files and recommended Access Database Recovery if you are facing problems of damage inaccessible or corrupt .mdb or .Access data base files.
ReplyDelete