Hi Mike. Thanks for your reply
This is happening on DBF tables ..just wondering is this relevent then --> we disable the OptLocks and allocated more memory to the SQL server and these seem to have resolved the issue (its been 2 months we have not seen this error now.)

Regards,
Gerard


>>I am getting this error on a New Site. (Invalid seek Offset Error)
>>It happens infrequently
>>If I run exactly the same code a second time, I might not get the error
>>Seems to be happening on a command like: Total on MyField to MyNewTable
>>(This could ake from 5 - 30 seconds to run)
>>
>>The only other time I have seen this is when someone pulls out a network cable in the iddle of a processng Run, but in the current situation, this is definitely not happening (I am on RDP into a server). The Exe hangs and if I use TaskMgr to stop it, I can go back in and run the process again, and it may or may not show the problem
>>Thanks in advance
>>Gerard
>
>We have encountered this error recently. After much reading and since this error is pratically untrappable, we disable the OptLocks and allocated more memory to the SQL server and these seem to have resolved the issue (its been 2 months we have not seen this error now.)