ACC1: Additions to User's Guide Appendix A Specifications

• 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