I don't know if this is related to the species lookup I posted earlier today, but on running an import on a different workstation which managed to lookup up the species without error, it runs all the way through the import until I press "Do Import" at which point it fails with the following error - any ideas would be helpful, I'm guess a privileges problem AGAIN but don't know where to start looking!

date/time         : 2010-01-20, 10:38:27, 859ms
computer name     : WS10
user name         : ser2
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 2 hours 7 minutes
program up time   : 46 minutes 38 seconds
processors        : 2x Intel(R) Pentium(R) 4 CPU 3.00GHz
physical memory   : 473/1023 MB (free/total)
free disk space   : (C:) 5.78 GB (R:) 12.00 GB
display mode      : 1680x1050, 32 bit
process id        : $aa4
allocated memory  : 39.75 MB
command line      : RecorderApp.exe /3670568
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 12:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : EDBMergerError
exception message : Error occurred transferring records for SQLSERVER_SURVEY_EVENT into the main database.

main thread ($fd8):
00704d68 RecorderApp.exe 
7c90e485 ntdll.dll        KiUserExceptionDispatcher
7e42a993 user32.dll       CallWindowProcA
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

thread $fe4:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df48 ntdll.dll     NtWaitForMultipleObjects
7c80958a kernel32.dll  WaitForMultipleObjectsEx
7e4195f3 user32.dll    MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll    MsgWaitForMultipleObjects
>> created by main thread ($fd8) at:
4ec67b7f gdiplus.dll   

thread $b64:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90df48 ntdll.dll  NtWaitForMultipleObjects

thread $320:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $c7c:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90d218 ntdll.dll  NtDelayExecution

thread $e18:
7c90e514 ntdll.dll   KiFastSystemCallRet
7c90daa8 ntdll.dll   NtReplyWaitReceivePortEx
>> created by thread $6c0 at:
77e7df36 RPCRT4.dll 

thread $248: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $948: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $b34: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject