No response on this so I assume everyone else is a baffled as I am.

I decided to try and import the data direct from the original zip file that I use to import to R2K2. This told me that the "missing" taxon occurrences were actually already in the database, since they were flagged up as duplicates. It also gave me the actual taxon occurrence keys, so I was able to double-check by a select directly on the database that they were all there - indeed they were.

So, for some reason Recorder 6 is choosing not to display these taxon occurrences.

This does remind me of a similar problem Sally Rankin reported with when taxon occurrences entered from the Environment Agency taxon dictionary in R2K2 were transferred to R6 - but if I recall correctly this is because that list was missing from R6. This is not the case here.

Again, I'd be very glad of any help.

Cheers

Alan

Just a thought, but have you tried rebuilding your indexes?

Nothing immediately strikes me  on this, but I would be happy to look at it  if you can send me the data.  I wouldn't have thought that it was anything that complicated assuming  the  taxon determinations are there ? 

Mike Weideli

Some progress with this.

I discussed on the phone with Sally this afternoon and we found, surprisingly, that pasting one of the missing rows in TAXON_DETERMINATION from R2k2 to the Rec6 linked Access database did NOT elicit any error. And when I the opened the Obs window in Rec6 the corresponding taxon occurrence was now visible!

Sally then suggested exporting the whole original TAXON_DETERMINATION to a new database, zipping it and importing into Rec6. I found however that I could not export the table - I kept getting a message from the JET engine saying another user was changing the data at the same time - which is very odd (I have stand-alone installations of both R2K2 and Rec6). I tried a Make Table query with no filter to get a copy of the table - same message. However, intriguingly, I was able to do a Make Tabe WITH a filter to just pick out the rows missing in Rec6. This looked promising, and I exported the new table to a new database, zipped it, and imported into Rec6 - apparently with no problem. However, the taxon occurrences STILL did not show up in the Obs window.

Then I thought of going back to the original zipped database that I imported the lichen data from into R2K2 in the first place, choosing All Imported to deal with duplicates. This seemed to work, with the caveat below:

At the very end of the import I got a message saying "Unable to insert the item since it references an item which does not exist". Very helpful! On brief inspection of the data, I found one taxon occurrence that was not now showing. Most were.

None of this explains why there was a problem with the original import. There were no references to the TAXON_DETERMINATION table in the UpgradeErrors.mdb. (It's worth noting here that there WERE a lot of errors reported relating to locations - these all seemed to derive from system data to do with Vice-Counties).

Now I'm going home!

Thanks for your help (and offers of help) everyone, especially Sally.

Cheers

Alan