Article ID: 302524 - Last Review: August 9, 2004 - Revision: 4.4

Specifications for an Access database and for an Access Project

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
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).

Expand all | Collapse all

SUMMARY

This article lists some of the most common specifications for Microsoft Access.
Back to the top

MORE INFORMATION

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 (http://msdn.microsoft.com) 
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
Back to the top

REFERENCES

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.

Back to the top
APPLIES TO
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
Back to the top
Keywords: 
kbinfo KB302524
Back to the top