>Hi Gar,
>
>In my case there is no sql and no view. just a table 'sostrs' in data environment.
>I am looping through another table with a relation set to sostrs. inside the loop i issue a
>replace statement. i think (?) that the first iteration of the loop is okay - but subsequent iterations return the record
>is in use error
>
>in other posts here, on a thread on 'error 109' - some suggested that if there was a grid where the control source
>references the table you are having a problem with, that you should temporarily eliminate the control source reference.
>i tried this, but it didn't work.
>
>i have continued to look at the code, and, oddly, as best as i can tell so far, an earlier version of the code works.
>yet the only differences (i think) between the current version and the old version are
>(some select statements into cursors are made - but not on the table in question) and some text boxes and a
> grid column were added to a form.
>
>i don't see how these changes could cause this problem !

Two things you need to look at: make sure you are using optimistic buffering. If you are using pessimistic buffering the table will remain locked after you do the replace until you issue a tableupdate. The other thing is to make sure you are sitting on the right cursor. A select statement will cause you to move off the cursor you are sitting on.