>>One thing that irritates me in VFP is another intermittent error: 'A stored procedure is being executed.' It is a recurring error when we close the application and it encounters CLOSE ALL command. This error has been around since 3.0, we are now at 6.0. I hope it will be addressed in 7.0. Any workaround or ideas?

>
>Jess,
>
>That error is telling you a stored procedure is executing when the database is attempting to close. Find teh stored procedure that is running and fix it so it returns and doesn't just sit there. One real possibility is that you issue the CLOSE ALL from a stored procedure, or from a stored procedure you call the code that issues the CLOSE ALL.

You know why I call it weird? I cleaned up everything in the database: no more referential integrity, no stored procedures. Just the tables sits in the DBC. And the error is still recurring. It seems to me that it still executes stored procedure when it is no longer around. I don't know why? Maybe I did missed out something...