You are currently offline, waiting for your internet to reconnect

Specifications for an Access database and for an Access Project

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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

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 objectsNumber of fieldsin a table:           255Table size:           2 gigabytes minus the space needed for the system                      objectsNumber of characters in a Text field:           255 Number ofcharactersin a Memo field:      65,535 when entering data through the user interface;                       1 gigabyte of character storage when entering data                      programmaticallyNumber of characters in a record:          2,000 (excluding Memo and OLE Object fields)Number of characters in acell in the query design grid:          1,024Number ofcharacters in a text box on a form or report:            65,535Number of levelsof nested formsor 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:
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,535Number of levelsof nested formsor reports:           7   				
You can find all of the database and project specifications by clicking Microsoft Access Help on the Help menu in Microsoft Access, typing specifications in the Office Assistant, and then clicking Search to view the "Access Specifications" topic.

inf ACC2002 ACC2003

Article ID: 302524 - Last Review: 08/09/2004 16:43:52 - Revision: 4.4

  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • kbinfo KB302524