In an Access Database, Referential Integrity is connectivity between coupled database tables. It is generally enforced by the grouping of a Primary Key or alternate key (candidate key) and a foreign key (reference key). For referential integrity to grasp, any field of the table that is declared a foreign key can have only values from the primary or alternate key of the table.

It is the most beneficial concept of Access database that makes the relationship between two or more different tables and make them easier to access. There are two key advantages of Referential Integrity:

Ensure data integrity and connectivity based on primary key and foreign key

increase development productivity

It is also important when we use database in programming like ODBC (open database connectivity).

Sometimes, you may find it difficult to access the referenced table or sometimes it becomes inaccessible and displays some kind of error message. This problem generally occurs due to corruption in referential integrity or database relationship. This problem may also occur when a table has a Memo field or self-join and has enforced referential integrity.

To resolve such kind of problems, you need to change to Memo fields or your database to the Text fields to move the Memo fields to a new separate or unrelated table, and then use one to one (1:1) relationship.

Using this method, you can fix your problem in small databases, but in case of large databases like banks or companies, it become more difficult or sometimes impossible to check the relationship status of particular table to change the Memo fields of the table.

In these situations, where the database relationships get corrupted, it affects all the tables related to a particular table whose relationship is damaged. In these situations, you need to repair or restore the database relationship in order to make them accessible.

You can perform this task with the help of Access Recovery software. These are specially designed third party application software that can help you in restoring the corrupted database relationship. These software are also helpful in other database corruption and can repair the forms, macros and queries also.

There are some access repair software that can’t restore the corrupted relationship, so before purchasing the software you should make sure that it will work or not.

Stellar Phoenix Access Recovery software is a powerful data recovery software. This software support database relationship restoration means you can restore your database relationship with this software without making any change in the Memo fields of your database table. This software can repair the data in all possible cases of database corruption and can repair the corrupted tables and forms.