>- I am using Visual Foxpro back end database
>
>- Yes, I am using the same shared connection for all views. Is that the problem. I create the connection at the very beginning of the program.
>
>
>Thanks
>
>Raz


Did you set the connection to use manual transactions?
Then, send the table updates, if the return of all is .T. send a SQLCommit.

BOb