>Hi all,
> I have a colleague who works with FoxPro 2.0 for DOS.
>Does anybody can help him? Here is his question:
>**************************
> What is the reason of appearing an error message "file is in use" while
> FoxPro 2 is attempting to make sql-select,even if I have closed any .dbf
> before that?(except thoose explications in HELP)?
>
> Thank's a lot for Your kindness.
> _______
> {Kumar}
>*****************************
>
>Thank you
>Stoyka

There is one common situation for all fox versions: if you use table name in SELECT-SQL which is not currently open, then Foxpro will try to find it and open automatically depending on SET EXCLUSIVE setting and here you could get into multiuser problems.