7,714
社区成员
发帖
与我相关
我的任务
分享关于access的容量和速度的问题，经验丰富的高手请进
想问一个问题，access数据库的性能到底怎么样，本人手头有一个数据库是access的图片管理系统，前台是asp的，正在犹豫是否把它改成sql的，因为不知道access可以支持多少，应付一般的应用容量和速度是否能胜任，各位有经常使用access的请给点意见，up的兄弟们也有分。
...全文
请发表友善的回复…
发表回复
liuyann 2004-11-22
- 打赏
- 举报
不过建议你还是改成比较好
毕竟会稳定一些,数据备份也有保证
毕竟会稳定一些,数据备份也有保证
liuyann 2004-11-22
- 打赏
- 举报
Microsoft Access database general specifications
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
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
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
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
yesyesyes 2004-11-22
- 打赏
- 举报
对.请看access帮助-access规格.
zsh211 2004-11-22
- 打赏
- 举报
access可255个连接???????
yesyesyes 2004-11-22
- 打赏
- 举报
access可255个连接,sqlserver可32767个连接,sqlserver功能强大.
changechange 2004-11-22
- 打赏
- 举报
关于此主题请参考：
access数据库规格问题，如表能放多少字段，多大。。。《其他》
http://access911.net/index.asp?u1=a&u2=72FAB01E17DC
其实你的问题根本无从回答,因为你根本没有说出数据库的应用环境以及数据量
access数据库规格问题，如表能放多少字段，多大。。。《其他》
http://access911.net/index.asp?u1=a&u2=72FAB01E17DC
其实你的问题根本无从回答,因为你根本没有说出数据库的应用环境以及数据量
