Any ideas on why I would be getting "File in use by another user" on an Insert SQL command on a table that is already open? What the program is intended to do is generate master and detail records for a set of reporting tables, but occationally I get the "File in use by another user" when I try to Insert into the detail table. If I look at the error in the debugger, select the line with the Insert command and execute it again via Set Next Statement, the program continues on without a problem.

I have a feeling that it has something to do with the environment.

TIA