Hi Shawn ---
I've run into that resource problem myself. Are you using remote views? Or SQL Passthrough? Also, how is the data buffered?
>We have an app that builds transactions and then posts all the txs to the server.
>
>We have 30,000 txs or greater to post.
>
>Here some of the code in short
>
>do while !EOF()
> begin tran
> insert into .....
> end tran
>skip
>enddo
>
>The reason we do this is becasue with a trna on the outside it uses all resources on the clients machine. we can only get about 1200 records updated to the server. if we do it this way we can get 20000 but we still run out of resources. Doe any one know how to clear the cached space so we can clear the cache each time to get through all txs.
>
>TIA
>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