ms访问中的最大并发连接数 [英] Maximum concurrent connections in ms access

问题描述

ms-access支持的最大并发连接数是多少?

What are the maximum concurrent connections ms-access supports?

推荐答案

从理论上讲255，实际上取决于情况.如果它们大多是只读的，并且您所处的网络速度很快，那么在编写良好的数据库上我看到100多个都没有问题.另一方面，我敢肯定同样的恐怖故事也会出现，那就是数据库被2个用户破坏.是的，它确实有可能发生，但是如果您建立了一个好的数据库并且对您的数据库操作持现实态度，那么您会获得数量惊人的用户.

In theory 255, in practice well it’s depends. If they are mostly read only and the network you are on is fast then I have seen 100+ with no problems on a well written database. On the other hand I’m sure the same old horror stories of databases getting corrupt with 2 users will come up. Yes it can happen but if you make a good database and are realistic about what you do with it you can get a surprising number of users hanging off one.

从长远来看，您可能希望查看SQL Server的免费(快速)版本以获取更多用户.

In the long term you might want to look at the free (Express) version of SQL server for higher user counts.

这篇关于ms访问中的最大并发连接数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！