I have records in Recorder 6 which were entered long ago using the Recorder 3 list: example Atheta pertyi which is now Atheta aenicollis in the Preferred Coleoptera List. When I want to produce species maps in DMAP or an entry in my county Coleoptera list (using a bespoke Access routine) I find I get maps for both taxa and entries for both taxa in the county list, because the species have different Sort Order numbers. There are many other examples of this. I can achieve a correction by going into each A. pertyi record and changing the determination to the taxon A. aenicollis from the Preferred Checklist. This is OK if there are only a few records to deal with, but can get very tedious with many records. Is there a batch update that will deal with this?

In Tools>Run Batch Updates there are 4 items (Det 1, Det2, Det 4 and Det 5). Will one of these perform the task that I need here? The reason I ask this without trying them is that if something goes wrong it takes about 48 hours minimum to get a database restore via our IT system.

Any comments on this would be appreciated....

Since writing this post I have tried to run the Batch Update "Determination Updates > Det 1 Creates new Determination for specified taxa" on a standalone R6 installation. I enter the "old" taxon and the "new" taxon. When trying to run the Batch Update I get an error message which reads "The following error occurred while attempting to run the batch update SQL: Must declare the scalar variable "@New_TLI_Key"" What does this mean and does the batch update work properly?