This error is caused by delete query and when the unique property is set to no.

Following are the steps which should be taken to solve the problem.

☛ Delete query should be opened and if it is not opening then press F4

☛ Clicking the query properties underneath the query designer will give you options.

☛ In that options you need to locate unique records property and should set it to yes. These options are present in query property sheet.