access容量小一些,一般多少条数据,或者说数据库膨胀到多少m是比较安全的?
?? 问题点数：0、回复次数：3Top
1 楼liuyann（liuyann）回复于 2004-12-03 20:47:25 得分 0
下在是ACCESS的规格说明,
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
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
Top
2 楼liuyann（liuyann）回复于 2004-12-03 20:50:36 得分 0
我曾经有一个ACCESS达到过400M,问题倒没什么,不过每天提心吊胆的,后来还不换成ORACLE的
使不使用ACCESS主要不是容量的问题,而是安全,备份,效率,以及存储过程,触发器功能方面的要求.如无此方面的需求,则可用AccessTop
3 楼wangtiecheng（不知不为过，不学就是错！）回复于 2004-12-03 21:27:23 得分 0
Access数据库越大越慢，而且安全性也不好!Top
