Specifications for an Access database and for an Access Project (302524)

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:

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