Re: How do I ...Understand import error message
Hi
I have tried to import to R2K2 a file of bird data that i had recently typed up and seemed to be 'clean' - ie in the import process, all the species were correct, the people were correct, the places were correct and the notes about 'adult', 'male', etc were all as in the database. On import, 57 items were rejected, but which ones? I find the messages incomprehensible and there is no reference to the actual field and its contents that are the problems. How can I translate the technical gobbledegook into a message that might help me, the mere user? Examples are:
Failed to insert DSS00171000007KX into SAMPLE
Access Database Error Message:
Access Status 3201 - You can't add or change a record because a related record is required in table 'SURVEY_EVENT'.
DBI Error Code = Titan (BDE) Error 3201.
--------------------
Failed to insert DSS00171000007KM into SURVEY_EVENT_RECORDER
Access Database Error Message:
Access Status 3201 - You can't add or change a record because a related record is required in table 'SURVEY_EVENT'.
DBI Error Code = Titan (BDE) Error 3201.
--------------------
Any guidance would be very welcome so that I know what to do with the partially imported file.
Thanks in anticipation,
Cheers, Ian