Microsoft KB Archive/93691

{|
 * width="100%"|

ACC1: Additions to User's Guide Appendix A Specifications

 * }

Q93691

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

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

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

Issue type :

Technology :