>>>I have a routine that RE-INDEX about 54 files. When I go to reindex the files i get to reindex all of them. In other machines I get a message saying: TOO MANY FILES OPEN.
>>>
>>>Any clue on this message?
>>>Thanks.
>>Files that could be opened simultaneously is determined by OS and config.sys setting. A fox table with a CDX counts for 2 handles, if it has memo 3 handles and so on. The simpliest solution is to close the indexed one and open a new table so you will use minimum handles and don't have to check each stations files count.
>>Cetin
>W95 or NT?
What would it matter ? Both normally doesn't have that old dos limit. But if he's using a netware client software then probably files setting is at its default 40. Setting files a higher number in config.sys would eliminate the problem but should be done per station. Instead having the routine open one table per reindex is a better solution. George has already provided the sample code for that.
Cetin