I am interfacing with a third party VFP app and am having the devil of a time figuring out the cause of a sporadic error. The error I receive is "record in use by another" eventhough I am the only one logged in (100% sure of that). The error comes from a REPLACE statement that updates the grandchild table after the tables have been updated and the transaction is closed. As I said, I am the only one in the system, no other datasessions using the tables are open.

I have 3 native related VFP tables, a master (record buffered) a child and grandchild (both table buffered) updating within a transaction. I am not using any explicit table or record locks.

If I suspend at the point of the error, it's always on the same record.

To troubleshoot, I tried issuing an RLOCK() and it returns .F. If I then, move one or sometimes 2 records away and come back, most of the time RLOCK() still returns .F.. However, if I move 3 or 4 records away and then come back, it almost always let's me lock the record!

I saw in the DBC that the tables had default relationships set up and was wondering if this may have some impact. First question...What is the purpose of setting relationships in the DBC()? As far as I can tell they don't default to these relationships if I open the tables directly or from within a form...or do they?

I then thought that a stored proc may be firing, but they only have delete triggers.

The only other thing that may be a factor is that I have the child and gc table fields in a grid. By the way, the child and gc are one-to-one.

Any ideas as to what may be happening would be most appreciated!
TIA