The maximum capacity of Access is taken as an example of Access 2000? Open help, find the following entry: Set and define Microsoft Access -> Microsoft Access Specifications 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. Objects in the database 32,768 module (including? HasModule property is True? Forms and reports of TRUE? 1,000 object name of the character number 64 password character number 14 username or group name character number 20 users number 255MICROFT Access Project General Specification Properties Max Value in Microsoft Access Project (The number of. A number of objects in .adp 32, 768 module (including HasModule Attribute is True Forms and Reports) 1,000 Object Name Number of characters 64MICROSOFT Access database table Specifications Maximum Name The number of characters of 64 field name 64 table 64 Table 555 Open the number of tables 2,048. The number of tables that can be opened may be less, because Microsoft Access is also open to some internal tables. Table size 1G The character number of byte text fields 255 Number of note fields is input to 65, 535 via the user interface, and the field is input to a 1G byte. OLE? Object field Index in the 92 index in the 92 index 10 Validity Message Character 255 Validity Rule Character Number 2,048 Table or Field Description Character number 255 recorded characters (In addition to the note field and? OLE? Object field) 2,000 field properties set characters The number of 255Microsoft Access Database Query Specifications Maximum Value Implementation Relationship? Each table is 32 subtracting the number of indexes in the field or field combination in the table in the table 32 record set in the field Number 255 Recording Set Size 1G byte Sort Limits 255 Characters (1 or More Field) Nested Query Level 50 Query Design Grid Unit Number 1,024 Parameter Query Number Character 255where or Having The number of 40sql statements in the sentence is about 64,000 form and report specifications attribute the maximum number of characters in the maximum number of characters in the label. The number of characters in the text box is 65, 535 forms or report width 22 inch (55.87 cm) section Height 22 inch (55.87 cm) All sections plus the height of the section (in the "Design" view) 200-inch (508 cm) form or report can be sorted or packet in the largest nested grade 7 report or Expression 10 reports of the number of headers and footers 1 for reports header / report footer, 1 pair of page header / page footer, 10 sets of print pages of 10 groups of page / group footage 65,536 Add to Forms or Reports Controls and Sections 754 Macro Control Attribute Maximum Operations Number 999 Number of Totors 255 Number of Totors 255 Operation Parameter characters 255 ------------------------------------------ -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -Microsoft? Access? Project Specifications • Maximum Microsoft? Access? (. ADP) (Microsoft? Access? Project: With? Microsoft? SQLServer? Database connection and used to create customer / server applications? ACCESS? File.