You need to correct the problems in Recorder 2002 and then re-run the transfer. To track these down I suggest looking at the foreign keys in the taxon determinations, e.g. the taxon occurrence keys in them should be in the taxon occurrence table in Recorder 2002, although I have seen a number of databases where these have been missing. Presumably a problem existed in Recorder 2002 at some stage that allowed this to happen. You may be able to use other data in the taxon determination to track down the problem otherwise you may have no choice but to ignore instances of this error. Also check that the taxon list item keys are in the taxon list item table and the index taxon name table in Recorder 6. I am not convinced that user added taxa always transfer as they should. Also check the other foreign keys like entered by and changed by. If you have used the merge data items tool to merge people this may have caused problems as I suspect it doesn’t update these fields when it should although I have never had time to prove this.

As stated in section 3 of Sarah Shaw’s document – see her post on 24/09/07: http://forums.nbn.org.uk/viewtopic.php?id=449 – you can safely ignore the system supplied items in UpgradeErrors.mdb.