Microsoft KB Archive/302524

= Specifications for an Access database and for an Access Project =

Article ID: 302524

Article Last Modified on 8/9/2004

-

APPLIES TO


 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q302524



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
This article lists some of the most common specifications for Microsoft Access.



Microsoft Access Database Specifications (MDB):
Database file size:           2 gigabytes minus the space needed for system objects

Number of fields in a table:          255

Table size:          2 gigabytes minus the space needed for the 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; 1 gigabyte of character storage when entering data programmatically

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

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

Number of characters in a text box on a form or report:           65,535

Number of levels of nested forms or reports:          7

Microsoft Access Project Specifications (ADP):
NOTE: Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. For more information about SQL Server Books Online, visit the following Microsoft Web site:

MSDN, the Microsoft Developer Network

Number of columns in a table:          250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0 and 2000)

Number of characters in a text box on a form or report:           65,535

Number of levels of nested forms or reports:          7

