Remove duplicate relations Wizard
Using Remove duplicate relations (RDR) wizard you can remove duplicate relations in MS Access 97 database. Duplicate relations can appear when you import additional tables from the same database. You can see the following picture in Relationships window:
Duplicate relations can cause performance degradation (because of duplicate indexes) and impossibility to convert database to replica.
Just run RemDupRel.mde from MS Access 97, select database to repair and click OK. Open relationships windows to check that duplicate relations were gone.
PLEASE MAKE A BACKUP OF YOUR MDB FILE BEFORE OPENING IT WITH RDR WIZARD!
Download: RemDupRel.zip (25 kb)