Microsoft Access Database General Specifications Property Maximum Microsoft Access Database (.mdb) File Size 2 g bytes. However, since the database can include a link table in other files, its size is only limited by the available storage space. The number of objects in the database 32, 768 module (including the HasModule property is True Forms and Reports) 1,000 Object Name of the character number 64 password character number 14 username or group name character number 20 users number 255 Microsoft Access project General Specifications Attribute Max Value Object Number of Objects in Microsoft Access Project (.adp) 32,768 Module (including HasModule Attributes for True Forms and Reports) 1,000 Object Name Number 64 Microsoft Access Database Table Specifications Maximum Name The character number 64 field name is 64 tables in the field number 255 Open the number of numbers 2,048. The number of actually open tables may be less, because Microsoft Access also opens some internal tables. Table Size 1G byte text field Character number 255 Remarks The character of the field is input to 65, 535 via the user interface, and is input to 1G byte via the program. OLE object field Size 1G byte table Index 32 index in the field number 10 Validity message Character number 255 Validity Rule Number 2,048 Table or field Description Character number 255 recorded characters Number (In addition to the Number of Number of Number of Number of Remarks Field and OLE Objects) 2,000 Field Property Settings 255 Microsoft Access Database Query Specifications Maximum Value Performance Each Table 32 Split Table Not included in the relationship in the relationship Combined index number of tables in the number of numbers in the number of records 32 Record the field number 255 record set size 1G byte Sort by 255 characters (one or more fields) Nested query level 50 Query Design mesh unit Number of characters in characters 1,024 Parameter query parameter character number 255 WHERE or HAVING clause of the number of 40 SQL statement characters a number of 64,000 Forms and report specifications attribute larger tags 2,048 Text The characters in the box 65, 535 form or report width (55.87 cm) height 22 inches (55.87 cm) All sections (55.87 cm) window (in the design "view) 200 inch (508 cm) window Body or reported Maximum Nested Level 7 Report Can Sort or Group Fields or Expressions 10 Reports of Tetraels and Footers 1 Pair of Reports Header / Report Footage, 1 pair of page headers / Page footers, 10 sets of print pages for page 10 pages 65, 536 can be added to the controls of the form or report and the number of 754 Macro Split Properties Maximum Operations 999 Conditions Number 255 Number of Number 255 The number of characters of operating parameters 255 records are not limited, only by disk space limit and file size limit
