Microsoft Access 2010 Bible

Part VII: Appendixes

1248

TABLE A.2 (continued)

Attribute Maximum

Number of fields in an index or primary key 10

Number of characters in a validation message 255

Number of characters in a validation rule (including

punctuation and operators)

2,048

Number of characters in a table or field description 255

Number of characters in a record 4,000 (excluding Memo and OLE Object fields)

Number of characters in a field property setting 255

TABLE A.3

Queries

Attribute Maximum

Number of tables in a query 32

Number of enforced relationships 32 per table, minus indexes that are on the table for

the fields or combinations of fields that are not

involved in the relationship

Number of fields in a recordset 255

Maximum recordset size 1GB

Sort limit 255 characters in one or more fields

Number of levels of nested queries 50

Number of characters in a cell of the design grid 1,024

Number of characters in a parameter name for a

parameterized query

255

Number of ANDs in a WHERE or HAVING clause 99

Number of characters in a SQL statement Approximately 64,000

TABLE A.4

Forms and Reports

Attribute Maximum

Number of characters in a label 2,048

Number of characters in a text box 65,535

Form or report width 22.75 inches (57.79 centimeters)

Section height 22.75 inches (57.79 centimeters)

49_475348-bapp01.indd 124849_475348-bapp01.indd 1248 4/1/10 2:01 PM4/1/10 2:01 PM