I have seen this problem occur with TRANSACTIONs that haven't been ENDED. Check the TXLEVEL() function via Debug. If so, you have to find where in your app you are using BEGIN...END TRANSACTION and fix it :-)
>After exiting an application I get Error Message: 'A Stored Procedure is Executing' when all tables are closed and I execute, in a cleanup prg, the command CLOSE ALL. I'm running VFP5.0a.
>
>How do I find out what stored procedure is running?
>
>How can there be a stored procedure is running if there are no tables and no database open?
>
>How do I clear this condition other than with Alt-Ctrl-Del and restart VFP?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05