ACCESS database storage upper limit
ACCESS Database Storage Limit Access Specification Microsoft Access Database Specifications Access Database Properties The Max Value Microsoft Access Database (.mdb) File size 2G byte minus the space required for system objects. Objects in the database 32, 768 module (including "Inside the module" attribute is "Yes" Forms and Reports) 1,000 Object Name The number of characters of the number 64 password number 14 username or group name is 20 The number of concurrent users 255 table attribute maximum table name of the character number 64 field name of the character number 64 Table 555 Open the number of the table 2048; the number of actual open tables may be less, Because Microsoft Access is also open to some internal tables. The size of the table 2G byte minus the space "Text" field of the system object "Text" field "Text" "" Remarks "field of the character number is input to 65, 535 by the user interface; in programming mode, 1G byte character storage . "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 record The number of characters (except "Remarks" field and "OLE object" field) 2,000 field properties set characters 255 Query Property maximum perfect value per table is 32 minus tables are not included in the relationship Field or field combination index number of numbers in the number of numbers in the query 32 Record the field number 255 record set size 1G byte Sort by 255 characters (one or more fields) Nested query level number 50 query Design Grid A Character Number 1,024 Parameter Query Number Character 255 WHERE or HAVING Sentence A number of 99 SQL statement in the SQL statement is about 64,000 Forms and Report Attributes Maximum Tags Character number 2,048 Text box characters 65,535 Forms or report width 22 inch (55.87 cm) Height 22 inch (55.87 cm) All sections (in "design" view) 200 Inch (508 cm) form or reported Maximum Nested Layer 7 Report Can be used as a field or expression of the spectrum in the field or the number of items in the header and footer / report page Feet, 1 pair page header / page footer, 10 Volume 65, 536 of the Group Header / Group Foot report 65, 536 can be added to the number of controls and sections of the form or the number of 754 SQL statements as a form, report Or the "Record Source" or "Source" attribute of the control (for .mdb and .adp) 32,750 macro property maximum macro's operating number of characters in the number of characters in the number of characters in the number of 255 Remarks 255 Operation parameters A number 255 Microsoft Access Project Specifications Access Project Property Maximum Microsoft Access Project (.adp) Object Number 32,768 Module (including "Inside Module" attribute is "Yes" Forms and Reports) 1,000 Object Number The index in the character number in the table is 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0 and 2000) Microsoft SQL Server Database SQL Server Document describes the maximum capacity regulation of Microsoft SQL Server. grid. For more information on the SQL Server Book Series, see the Microsoft Developer's Network Web site. Note that the hyperlink in this topic will jump to the web, but you can switch back to Help at any time.