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 !