Microsoft KB Archive/89884

= Microsoft Knowledge Base =

PRB: &quot;Too Many Files Open&quot; Error in FoxBASE+/Mac
Last reviewed: February 16, 1996

Article ID: Q89884

The information in this article applies to:


 * Microsoft FoxBASE+ for the Macintosh, version 2.0

SYMPTOMS
An attempt to open a file in FoxBASE+/Mac fails with a &quot;Too many files open&quot; error.

CAUSE
There are three distinct reasons for this error message to occur:


 * 1) The Macintosh imposes a limit on the total number of files that can be open simultaneously that depends on the amount of available memory and on the installed version of the Finder system software. By default, the boot block specifies 10 files; this value may be set as high as 40 files.
 * 2) The FILES statement in the CONFIG.FX file specifies the maximum number of files that can be open simultaneously.
 * 3) The system attempted to open more than 21 indexes simultaneously.

RESOLUTION
Determine which limit applies and increase the limiting value. If the FILES statement CONFIG.FX is too small, modify the CONFIG.FX file to specify a larger number of files. The FILES statement counts only FoxBASE+/Mac files; it does not include any system files.

There is a third-party utility called Master Juggler that has a menu option called Set File Count. This option can be used to set up the size of the boot block. Master Juggler is included in the book titled &quot;Big Mac Secrets.&quot;

MORE INFORMATION
A relation is not counted as an open file. To determine the number of files required, count the number of text files, views, indexes, format files, screen files, and databases. Then add three files to account for FoxUSER, a temporary file, and a FoxBASE+/Mac program application. If Help is used, add two additional files.