Microsoft Access Database General Specifications

xiaoxiao2021-03-06  98

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 Database Table Specification Name The character number 64 field name of the character number 64 Table of the field number 255 Open the number of the table 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