I am trying to delete a number of surveys and am unable to do so using either the delete survey add in or the JNCCdel5Records [1] batch update. When I use the add in I get a "failed to delete survey" dialogue box with no effect on the survey itself. When I run the batch update I get a box with the following:

"There is an error in the SQL code. The error message is: 'The DELETE statement conflicted with the REFERENCE constraint "FK_SAMPLE_RECORDER_SURVEY_EVENT_RECORDER". The conflict occurred in database "NBNData", table "dbo.SAMPLE_RECORDER", Column "SE_RECORDER_KEY"

I have been able to delete surveys much larger than this previously with no problem. These surveys did come from another copy of recorder with custody reassigned.

I need to remove them and reimport to deal with a related problem which I recently posted regarding duplicate copies of Recorder6 in use by one of our data providers.

Any help most gratefully received.

Martin