-
The user in some cases may get the below Error Message when Restoring a Project. This message indicates that there are some pages in the Project which have entries of duplicate pages with different Installation / Location / Drawing Set. Some of the duplicate pages will be having Installation / Location / Drawing Set. This Wiki Article focuses on how to find the pages that have duplicate entries for pages.Important Note: The for following the below steps the user needs to have Microsoft Access Installed on the machine. Also, they should create backup of the Project Backup so that in case of any issues user can refer to the backup file.
1. Browse to the location where the Project Backup file is for which the issue being faced is located using Windows Explorer. 2. Right-click on the Project Backup file and select 7-Zip >> Open Archive.3. Now in the &-Zip Dialog select the "ECADProject.mdb" file and use the Copy Option to create a copy of the file on the local machine. 4. Go to the location where the MDB file is copied and then open it with Microsoft Access.5. After opening the file in Access go to Create >> Query Wizard >> in New Query dialog select Find Duplicate Query Wizard.6. Now for the results table select Table: Page >> Next. 7. Now select "File Name" to check for Duplicate-Value Fields.8. Select all the Available Fields select Finish.9. In the Result Table if there are entries then there are duplicate records in database for a single drawing. The user can decide which record to delete by referring the Drawing Set / Installation / Location. In the below screen shot example it can be seen that all the Drawing Set Ids from the page table are not present in "Drawing Set" table. But the users need to check other tables as well as well like Installation / Location / Page Format if the issue is not in Drawing Set.10. After identifying the record which is duplicate the duplicate records need to be deleted. This can be done by Right Click on the record and select Delete Record. 11. After Deleting all the duplicate records, Save the file. 12. Now Drag and Drop the MDB file into the 7-Zip dialog Step 3 and say Yes in the dialog. after copying close the 7-Zip dialog.