access数据库存储上限（Access database storage cap）.docVIP

access数据库存储上限（Access database storage cap） Database: ] Attribute maximum Microsoft Access database (.Mdb) file size 2G bytes minus the space required by the system object. The number of objects in the database is 32768 Modules (including containing modules, attributes as yes forms and reports) 1000 The number of characters in the object name 64 The number of characters in the password is 14 The number of characters in the user name or group name is 20 The number of concurrent users 255 surface Attribute maximum The number of characters in the table name is 64 The number of characters in the field name is 64 The number of fields in a table 255 The number of open tables is 2048; the number of actually open tables may be less, because Microsoft Access also opens some internal tables. The size of the table 2G bytes minus the space required by the system object The number of characters in the text field 255 The number of characters in the memo field is entered through the user interface to 65535; the character storage for 1G bytes is entered programmatically. The size of the OLE object field 1G bytes The number of indexes in the table 32 The number of fields in the index 10 The number of characters for the valid message 255 The number of characters in the rule of validity 2048 The number of characters for a table or field description 255 The number of characters recorded (except for the remark field and the OLE object field) 2000 Field properties set the number of characters 255 query Attribute maximum The number of relationships implemented; each table is 32 minus the number of indexes in the table that are not included in the relation field or field combination The number of tables in the query 32 The number of fields in the record set is 255 Record set size 1G bytes Sort limits 255 characters (one or more fields) The number of times the nested query is 50 Query design grid the number of characters in a cell 1024 Number of argument characters for parameter queries 255