Microsoft KB Archive/113440

= MS Access Version 1.1 Specifications & Limitations for VB 3.0 =

PSS ID Number: 113440

Article Last Modified on 10/29/2003

-

The information in this article applies to:


 * Microsoft Visual Basic Standard Edition for Windows 3.0
 * Microsoft Visual Basic Professional Edition for Windows 3.0

-



This article was previously published under Q113440



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.



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 query words: specs spec limit limits limitations 3.00

Keywords: KB113440

Technology: kbAudDeveloper kbVB300 kbVB300Search kbVBSearch kbZNotKeyword2 kbZNotKeyword6

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.