Specifications for an Access database and for an Access Project

Article translations Article translations
Article ID: 302524 - View products that this article applies to.
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.

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

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.

Properties

Article ID: 302524 - Last Review: August 9, 2004 - Revision: 4.4
APPLIES TO
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbinfo KB302524

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com