Q68462: ISAM Files Open at Once, "Too Many Files" Error 67, Correction
Article: Q68462 Product(s): See article Version(s): 7.00 7.10 | 7.10 Operating System(s): MS-DOS | OS/2 Keyword(s): ENDUSER | docerr | mspl13_basic Last Modified: 29-JAN-1991 Page 673 of the "Microsoft BASIC 7.0: Language Reference" (under the "Too many files" error in Appendix D) incorrectly states that ISAM is limited to opening 12 databases at once. This should be corrected to read as follows: At run time, the "Too many files" error may occur because: ISAM has a limit to the number of databases and tables that can be open at one time and your program has exceeded this limit. The maximum number of database files that you can have open at once is four. Also, the maximum number of tables that you can have open at once is 13 tables in one database file, or 10 tables in 2 database files, or 7 tables in 3 database files, or 4 tables in 4 database files. This information applies to Microsoft BASIC Professional Development System (PDS) versions 7.00 and 7.10 for MS-DOS and 7.10 for MS OS/2. Reference: An ISAM database file in Microsoft BASIC Professional Development System (PDS) version 7.00 or 7.10 is created with the default extension .MDB and contains the physical data for each table plus the indexes used to define and point to the data. (This correct ISAM information is taken from page 388 of the "Microsoft BASIC 7.0: Programmer's Guide" for versions 7.00 and 7.10 [Chapter 10, "Database Programming with ISAM"].)
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
Copyright Microsoft Corporation 1986-2002.