Access™ 2007 Bible

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. Databases

Attribute	Maximum
ACCDB or MDB file size, including all database objects and data.	2GB, minus space needed for system objects (Because your database can include attached tables in multiple files, its total size is limited only by available storage capacity.)
Total number of objects in a database (tables, queries, forms, reports, and so on)	32,768
Number of modules, including modules attached to forms and reports	1,000
Number of characters in object names	64
Number of characters in a database password	14
Number of characters in a username or group name	20
Number of concurrent users	255

Table A.2. Tables

Attribute	Maximum
Number of characters in a table name	64
Number of characters in a field name	64
Number of fields in a record or table	255
Number of open tables	2,048, including system tables opened by Microsoft Access internally
Table size	2GB (minus space needed for system objects)
Number of characters in a Text field	255
Number of characters in a Memo field	65,535 when entering data through the user interface; 1GB when entering data programmatically
Size of OLE object field ...