Open help, find the following entry
Set and define Microsoft Access -> Microsoft Access Specifications
Go see it yourself.
Access 2000 Chinese version as an example
Open help, find the following entry
Set and define Microsoft Access -> Microsoft Access Specifications
Go see it yourself.
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 form and report) 1,000 object name of the character number 64 password character number 14 user name or group name character number 20 users number 255
Microsoft Access Project General Specifications Properties Maximum Number of Objects in Microsoft Access Project (.adp) 32,768 Module (including HasModule Attributes for True Forms 1000 Object Name) Number of characters 64
Microsoft Access Database Table Specification Properties maximum value table name of the character number 64 field name of the character number 64 table 555 Open the number of tables 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 of characters set in 4,000 field properties 255
Microsoft Access Database Query Specifications The maximum value of the maximum value per table is 32 subtracting the number of fields in the field or field combination in the relationship, the number of numbers in the number of numbers in the number of fields in the number of fields 255 Recording Set Size 1G byte Sort Limits 255 Characters (One or More Field) Nested Query Level 50 Query Design Number of characters in Design Grid 1,024 Parameter Query Number Characters 255 Where or HAVING clause The character of the number of 40 SQL statements in And is about 64,000
Forms and Report Specifications Properties Maximum Tags in the Max Number of 2,048 Text boxes 65,535 Forms or report Width 22 inch (55.87 cm) Height 22 inch (55.87 cm) All sections plus a section Height (in "Design" View) 200 Inch (508 cm) form or reported to the number of fields or groups of fields or expressions in the field or the number of items in the header and footer 1 Reports Header / Report Footer, 1 Pair of Page Header / Page Footage, 10 Groups of Print Pages for Terminals 65,536 Add to Forms or Reports 754
Macro-grid Property Maximum Macro Operation Number 999 Total Number 255 Note The number of characters 255 Operation parameters The number of characters 255
The number of records is not limited, only by disk space limit and file size limit
