标题: SOS [打印本页] 作者: slimshelly 时间: 2003-6-22 17:52 标题: SOS 编辑一个Access的数据库
大概数据的存储量有几万条
问Access最大的存储量是多少？？？？？？？作者: 李啸林 时间: 2003-6-22 18:01
没试验过.
几万应该不成问题.作者: slimshelly 时间: 2003-6-22 18:07
可是我的初试有几万条
但以后可能有20万条左右
可以承受吗？作者: 我要飞 时间: 2003-6-22 18:57
Access2000的设计极限是10亿(总记录数)，不知是真是假，谁也没试过。作者: QINGSOLI 时间: 2003-6-22 21:12
DATABASE
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes minus the space needed for system objects.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
Table
Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048; the actual number may be less because of tables opened internally by Microsoft Access
Table size 2 gigabyte minus the space needed for the system objects
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte of character storage when entering data programmatically
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255 作者: baije 时间: 2003-6-23 01:07
最多存2G，和记录条数无关！