O'Reilly logo

Access™ 2007 Bible by Gavin Powell, Joseph C. Stockman, Jennifer Reardon, Michael R. Groh, Michael R. Irwin, Cary N. Prague

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required