Thank you for the responses, although I am still missing something.

It is buffered because I am doing a tableupdate after but I am not sure where it is set to buffering.

I tried the TableRevert and more and still get the error. I converted the replace to a scan and same error.

I do not know how to NOT share the connection.

Here is more information. I have a database container ECOMDATA. It has remote views to more than two tables in an access table. Sometimes these work. I have put a CLOSE DATA ALl before the commands and still get the error.

Here is the code: I get the error on the first REPLACE. I left in some of the stuff I was trying. Note: If I suspend and then continue it works, but if I try trapping the error I get the error everytime I retry.
*BEGINNING OF CODE
select 0
use ecomdata!orderse
*Messagebox("Ready to Update Fulfilled Orders")
*on Error Do waitODBC in Proced
* Success's
*tableRevert(.T.)
*!* scan for !orderse.fulfilled AND !orderse.deleted AND alltrim(orderse.transactstatus) == "success"
*!* Replace fulfilled with .T.
*!* endscan

*!* scan for !orderse.fulfilled AND !orderse.deleted AND ( alltrim(orderse.transactstatus) <> "success" OR isnull(orderse.transactstatus))
*!* Replace deleted with .T.
*!* endscan
if !TableUpdate(.T.)
Messagebox("Wait")
Endif

replace fulfilled with .T. for !orderse.fulfilled AND !orderse.deleted AND alltrim(orderse.transactstatus) == "success"
* Rejected Credit Card Orders
replace deleted with .T. for !orderse.fulfilled AND !orderse.deleted AND ( alltrim(orderse.transactstatus) <> "success" OR isnull(orderse.transactstatus))

*on error
if !TableUpdate(.T.)
messagebox('Orders on Ecommerce Update Unsuccessfully marked as Fulfilled or Deleted.')
endif
use
*END OF CODE

Thank you Chris.