Matthew Metlis wrote:

> I'll check to see if each step is done in its own transaction, or
> whether they are all in one transaction.

Err, if you're sure you're closing the connection, you can't be
in the same transaction. On some operating systems it's possible
to delete a file that's in use by an application. The application
continues to run against the old file. When it closes and reopens
the file, there's a whole new world. I think that's what you're
seeing. You shouldn't have to close the application, but be
sure that all connections are closed.


Regards,


Ann