This article was previously published under Q302524
This article has been archived. It is offered "as is" and will no longer be updated.
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.