KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

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.