>I have set the buffer to 5 already to update manually and only editing the records and not adding any and the error still the same "Conflict Update on cursor..."

Then aError() is your friend.

lRet=tableupdate()
if not lRet
   aError(ee)
   set step on && and look at the ee array in the debugger
endif

Check on the backend that the record with that PK that you're trying to update actually exists. Also, if there's some kind of profiler or log on the server, try to see what was the actual command that Fox sent to it, then try to execute that command right there, in whatever tool you have at your disposal (or as a SPT command, that would work too). I'm not promising a solution, this is only a way to debug this kind of issue.