Hi Walter,
Thanks for your reply.
>You can see which indexes are open when you save your setting in an ASCII file with DISPLAY STATUS TO file.txt NOCONSOLE in your error handling routine.
That's exactly what I'll do, thanks for the suggestion.
>I'll bet there is one or more non-structual indixes blocking your transaction.
I don't doubt it for a second. They're just proving very hard to track down.
Regards,
Liam
Liam O'Hagan
MCP VFP Desktop Apps