MS Access Version 1.1 Specifications & Limitations for VB 3.0

 Last reviewed: August 7, 1995
Article ID: Q113440
The information in this article applies to:

- Standard and Professional Editions of Microsoft Visual Basic 

  Programming System for Windows, version 3.0

SUMMARY

This article lists the Microsoft Access version 1.1 Specifications from Appendix A of the Microsoft Access User's Guide. We are providing it here for the benefit of Visual Basic programmers.

MORE INFORMATION

Database

   Attribute                                                Maximum
   -------------------------------------------------------------------
   .MDB file size                                           1 gigabyte
   Number of tables in a database                           32,768
   Number of attached tables in a database                  32,768
   Number of queries in a database                          32,768
   Number of open tables                                    254
   Number of characters in object Names                     64
   Number of characters in password                         14
   Number of characters in user name or group name          20
   Number of concurrent users                               255

Tables

   Attribute                                                Maximum
   -------------------------------------------------------------------
   Number of characters in a table name                     64
   Number of characters in a field name                     64
   Number of fields in a record or table                    255
   Table size                                               1 gigabyte
   Number of characters in a text field                     255
   Number of characters in a memo field                     32,000
   Size of OLE Object field                                 1 gigabyte
   Number of indexes in a record or table                   32
   Number of fields in an index                             10
   Number of characters in a validation message             255
   Number of characters in a table of field description     255

Queries

   Attribute                                                Maximum
   -------------------------------------------------------------------
   Number of tables in a query                              16
   Number of fields in a dynaset                            255
   Dynaset size                                             1 gigabyte
   Number of sorted fields in a query                       10
   Number of levels of nested queries                       50
   Number of characters in a cell                           255
   Number of ANDs in a WHERE or HAVING clause               40

Additional reference words: specs spec limit limits limitations 3.00
KBCategory: kbref
KBSubcategory: RefsDoc RefsProd

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.

Last reviewed: August 7, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.