Have you played with the ShareConnection "View" property (DBSETPROP)? I have found that changing that setting to .F. helps with resources. What about using SQL passthrough and setting transactions to manual? You can then use SQLCOMMIT and SQLROLLBACK to manage that transactions. This is what I generally do.
>The tables are optimistic buffering and we are using remote views.
>We tried to use SQLpassthrough but we have had no luck with the passing the parameters to the server becasue we get a connection busy from the ODBC.
>
>Any suggestions...
>Shawn
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05