Re: Importing Documents into Recorder2002
Hi
We have been trying to import a document that we created from one recorder2002 database to another to avoid having duplicate documents, but we can't get it to work.
We placed the document in a rucksack then exported the rucksack ("Include observations" was unchecked) when we then tried to import it into the other database it came up with a message saying 2 items succesfully imported and 2 items rejected and there was no sign of the document in the database. The ImportRejects text file created had the following in it
Items rejected by Recorder 2000 in data imported at 10-24-24 on 10/02/2010:
Failed to insert SR000291000000I8 into REFERENCE
Access Database Error Message:
Access Status 3201 - You can't add or change a record because a related record is required in table 'SOURCE'.
DBI Error Code = Titan (BDE) Error 3201.
--------------------
Failed to insert SR000291000000LP into REFERENCE_AUTHOR
Access Database Error Message:
Access Status 3201 - You can't add or change a record because a related record is required in table 'REFERENCE'.
DBI Error Code = Titan (BDE) Error 3201.
--------------------
Any ideas what we are doing wrong?