Appendix A: Access 2007 Specifications

In This Appendix

Identifying the Access 2007 specifications and limits

Looking at limits for Access 2007 tables, queries, forms, and reports

Reviewing limits for SQL Server 2005 Standard Edition and SQL Server 2005 64-bit Standard Edition

This appendix shows the limits of Microsoft Access database files, tables, queries, forms, reports, and macros.

Microsoft Access Database Specifications

Table A-1

Table A-2

Table A-2

Table A-3

Table A-4

Table A-4

Table A-5

Access Data Projects (ADP) Specifications

Table A-6

Table A-7

Table A-8

Microsoft SQL Server 2005 Database Specifications

The capacities of SQL Server 2000 databases are the same as SQL Server 2005. With the exception of database size, the values in this table apply equally to Microsoft SQL Server 2005 Express Edition. The maximum size of a SQL Server 2005 Express database is 4GB.

The maximum size of data managed by SQL Server 2005 is practically unlimited because of SQL Server’s ability to be configured as clustered database servers.

Table A-9

Table A-9

Table A-9