Microsoft Access 2010 Bible

Appendix A: Access 2010 Specifications

1249

Attribute Maximum

Height of all sections plus section headers in Design

view

200 inches (508 centimeters)

Number of levels of nested forms or reports 7 (form-subform-subform)

Number of fields/expressions you can sort or group

on (reports only)

10

Number of headers and footers in a report 1 report header/footer, 1 page header/footer, 10

group headers/footers

Number of printed pages in a report 65,536

Number of characters in a SQL statement that is the

Recordsource or Rowsource property of a form,

report, or control (both .mdb and .adp)

32,750

Number of controls or sections you can add over the

lifetime of the form or report

754

Number of characters in a SQL statement that serves

as either the RowSource property of a form or report

or the ControlSource property of a control

32,750

TABLE A.5

Macros

Attribute Maximum

Number of actions in a macro 999

Number of characters in a condition 255

Number of characters in a comment 255

Number of characters in an action argument 255

Microsoft SQL Server Express

Specifications

With the exception of database size, the values in this table apply equally to Microsoft SQL Server

2005 and 2008 Express Edition. The maximum size of a SQL Server 2005 or 2008 Express data-

base is 4GB.

The maximum size of data managed by SQL Server 2008 editions (other than Express Edition) is

practically unlimited because of SQL Server’s ability to be configured as clustered database servers.

Any single SQL Server installation (other than the Express and Compact editions) is 524TB.

49_475348-bapp01.indd 124949_475348-bapp01.indd 1249 4/1/10 2:01 PM4/1/10 2:01 PM