Microsoft Access Database General specifications

access| Data | database
Microsoft Access Database General specifications
Attribute Maximum Value
Microsoft Access database (. mdb) file size 2 G bytes. However, because the database can include linked tables in other files, its size is only actually limited by the amount of available storage space.
Number of objects in the database 32,768
Modules (including forms and reports with the HasModule property to True) 1,000
The number of characters for an object name 64
Number of characters for a password 14
Number of characters for user or group names 20
Number of users 255

Microsoft Access Project General specifications
Attribute Maximum Value
Number of objects in a Microsoft Access project (. adp) 32,768
Modules (including forms and reports with the HasModule property to True) 1,000
Number of characters in Object name 64

Microsoft Access Database Table specifications
Attribute Maximum Value
Number of characters in table name 64
Number of characters for field names 64
Number of fields in a table 255
Number of open tables 2,048. The number of tables that can actually be opened may be less, because Microsoft Access also opens some internal tables.
Size of table 1G bytes
Number of characters in a text field 255
The number of characters in the Memo field is entered as 65,535 through the user interface and is entered as 1G bytes by the program.
Size of OLE Object field 1G bytes
Number of indexes in a table 32
Number of fields in the index 10
Number of characters for a validation message 255
Number of characters for a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in the record (except Memo field and OLE Object field) 2,000
Number of characters set by field property 255

Microsoft Access Database Query specifications
Attribute Maximum Value
Number of implementation relationships each table is 32 minus the number of indexes in a field or combination of fields that are not included in the relationship in the table
Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1G bytes
Sort limit 255 characters (one or more fields)
Series of nested Queries 50
Number of characters in the query design grid cell 1,024
parameter query with number of parameter characters 255
Number of and in the WHERE or HAVING clause 40
The number of characters in the SQL statement is about 64,000

Form and report specifications
Attribute Maximum Value
Number of characters in the label 2,048
Number of characters in a text box 65,535
form or report width 22 inches (55.87 cm)
Section height 22 inches (55.87 cm)
Height of all sections plus section headers (in Design view) 200 inches (508 cm)
Maximum nesting series for a form or report 7
Number of fields or expressions that can be sorted or grouped in a report 10
Number of headers and footers in Report 1 for report Header/Report footer, 1 for Page Header/page footer, 10 group header/group footer
Printed page 65,536 of report
Number of controls and sections that can be added to a form or report 754


Macro Specifications
Attribute Maximum Value
Number of actions in a macro 999
Number of characters in a condition 255
Number of characters in a note 255
Number of characters for action arguments 255




No limit on record bars, limited by disk space limit and file size