ACC1: Additions to User's Guide Appendix A Specifications

ID: Q93691


The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1


SUMMARY

This article includes additions to the Microsoft Access "User's Guide," Appendix A, "Microsoft Access Specifications." Note that some but not all of this information may already be in the Microsoft Access "User's Guide."


MORE INFORMATION


 Tables
 ------

 Attribute                                          Maximum
 ----------------------------------------------------------
 Number of primary key fields and matching fields
 when defining a relationship between tables        5

 Queries
 -------

 Attribute                                          Maximum
 ----------------------------------------------------------
 Number of characters in a cell                     255
 Number of GROUP BY fields in a totals query        10
 Number of fields allowed when query property
 UniqueValuesOnly is selected (SELECT DISTINCT)     10
 Number of ANDs in a WHERE clause (criteria)        40
 Number of ANDs in a HAVING clause                  40 

Additional query words: queries tables limits limitations spec

Keywords : kbusage GnlApp
Version : 1.0
Platform : WINDOWS
Issue type :


Last Reviewed: March 12, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.