SOS

slimshelly

编辑一个Access的数据库
大概数据的存储量有几万条
问Access最大的存储量是多少？？？？？？？

李啸林

没试验过.
几万应该不成问题.

slimshelly

可是我的初试有几万条
但以后可能有20万条左右
可以承受吗？

我要飞

Access2000的设计极限是10亿(总记录数)，不知是真是假，谁也没试过。

QINGSOLI

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

最多存2G，和记录条数无关！