It is not a 'problem' per-say. DOS can handle only a limited number of files that are open at any one time, the default, I think, is 10. For each additional file you allow conventional memory is allocated, I don't know how much right off hand, I think it may be 4K. Just to start up Foxpro requires six or eight file handles. One file handle is used for each table you have open, plus one for each index. You need to calculate the max number of concurrent files you have in your program, then add an additional amount for temporary files (I would use 50% of max to start with). You have to be careful though because if you make any calls to DOS external or other libraries you may not have enough conventional memory to run.
//:^)
>In my config.sys I increased number of files from 20 to 40. Do you know FoxPro settings, which can cause my problem ?.
>
>Thanks for your help.
>Igor Gelin
>
>
>>>In my program (Foxpro 2.5 for DOS running under Windows95 ) I have special function for opening several(~15) tables:
>>>
>>>Select 0
>>>Use ... Index ...
>>>
>>>... ...
>>>
>>>Select 0
>>>Use ... Index ...
>>>
>>>In the middle of the function I got error: File 'welcome' doesn't exist.
>>>But this table does exist and is not corrupted, because I open it in Foxpro.
>>>
>>>Thanks for help
>>>Igor Gelin, System developer
>>Try changing the FILES=nn statement in your config.sys to increase the number of available file handles.
>>HTH
>>//:^)