>I am getting Error 1538 'A stored procedure is executing' when issuing a CLOSE DATABASES ALL command. I have two stored procedures, for indexes on one table in a database only. Nothing is being executed to my knowledge when I issue CLOSE DATABASES ALL.
>
>I can't force to let me CLOSE ALL from the command window, let alone trap it programmatically and proceed (have to quit FoxPro).
>
>The MS Knowledge Base is mute, but there is a hint that if another database is current, the one with the procedures can cause problems.
>
>Can anyone help?
>
>John Burton

I am not so sure if PACK DATABASE command is the absolute solution to this problem. But since we PACKED the DBC, this error is no longer appearing on our apps. Try it on the command window and see...

OPEN DATABASE yourdatabasename EXCL
PACK DATABASE

It appears that some of the stored procedures that were deleted on the DBC is still executing...