大公司的Access或者MySQL
一个月以来，我在法国的一家大公司工作。他们要求我制作一个应用程序来管理他们的计划。我使用他们现有的 Access 数据库和 VB.net 开发了一些不错的东西。 问题是，几个月后，该应用程序可能会被 70 名员工使用，而今天只有 10 名员工使用它。 所以我做了很多研究，我读到 Access 不能同时支持超过 20 个连接。 首先，这是真的吗？使用包含 70 名员工的 Access 数据库会带来什么风险？ 然后，您对我的案例中的 MySQL 有何看法？该应用程序不会连接到互联网，只能连接到内联网。我花了很长时间将我的应用程序连接到MySQL，但现在我不知道如何连接内网中的应用程序。 事实上，我对 SGDB 的选择有点迷失。
我对我的英语和糟糕的解释感到抱歉，但我是法国人，我没有在法语论坛中找到我的问题的答案。
感谢那些愿意帮助我的人。
Since a month, i'm working for a big company in France. They asked me to make a application manage their plannings. I devellopped something not so bad using their existant Access database and VB.net.
The problem is that in a few months, the application will maybe be used by 70 workers while today only 10 use it.
So i did a lot of researches, and i read that Access could not support more that 20 connection in the same time.
Firts, is that true ? What do I risk with an Access database for 70 workers ?
And then, what do you think of MySQL in my case ? The application won't be connect on internet, only on intranet. I took a very long time to connect my application to MySQL, but now i don't know how to connect the application in intranet.
In fact i'm a bit lost with the choice of my SGDB.
I'm sorry for my English and my bad explanations but i'm french and i didn't find the answers to my questions in french forums.
Thanks to those who will help me.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
请使用MySQL。
几乎没有理由使用 Access 后端。
就像你说的，Access的连接能力很差（每次打开数据库时，只要程序仍然打开，就会创建一个连接）。此外，它的备份选项很差（您真的想每天制作文件副本吗？）。
另外，Access 有一个“修复和压缩数据库”选项（对于 MDB，不确定较新的格式）。从我日常使用 MDB 的经验来看，它的数据一致性记录很差。
MySQL 为您提供可靠的数据存储，可以正确地汇集连接，它具有事务支持，并且您还可以在其上运行适当的备份。
您可以拥有 MySQL 后端，并使用 Access 表单作为前端。我认为这应该是一个足够好的折衷方案，并且可以让您轻松扩展它。
Please, use MySQL.
There is almost no excuse to use Access backend.
Like you said, Access has very poor connection abilities (every time the database is open, a connection is created as long as the program is still opened). Also, it has poor backup options (do you really want to make copies of the file every day?).
Also, Access has a "repair and compress database" option (for MDB, not sure about the newer format). It has a poor record of data consistency from what I experience with MDBs daily.
MySQL gives you a reliable data store, connections can be pooled properly, it has transaction support, and you can also run proper backups on it.
You can have a MySQL backend, and use Access forms as a frontend. I expect this should be a good enough compromise, and lets you scale it easily.
MySql 可以处理非常大的项目，它稳定、更新且免费，所以我认为您不应该考虑继续使用 Access。
连接到 MySql 将非常容易：包含 MySql.Data.dll 并更改数据库连接字符串，这很容易，您会在互联网上找到很多示例。
如果您的应用程序只应与 Intranet 中的数据库通信，只需在服务器上安装 MySql 并使用服务器 IP 和端口连接您的应用程序即可。
MySql can handle very large projects, it's stable, updated and free, so I think you shouldn't think to go on with Access.
Connecting to MySql will be quite easy: include MySql.Data.dll and change db connection string, it's easy and you'll find a lot of examples on internet.
If your app should only talk with db in intranet, simply install MySql on a server and connect your app using server ip and port.
我发现 Access 数据库的安全性非常差，而且速度非常慢。如果您打算在生产环境中运行几天后打开访问数据库，您会发现它有多慢。
虽然看起来您是 MySQL 的新手，但您不需要太多的学习曲线就可以使用它。 MySQL 有很多用户，您在解决 MySQL 相关问题时也会得到很好的支持。最重要的是，您将能够学习 MySQL，我相信您稍后会将其用于您创建的其他应用程序。
I have seen Access database have real poor security and which is terribly slow. If at all you intend to open your access database after a few days of running in production, you will see the how slow it can be.
Though it looks like you are new to MySQL, you will not need much of a learning curve to work with it. MySQL have lot of users that you will get a good support for you MySQL related questions also. And the best of all you will be able to learn MySQL, which i am sure you will use later for other applications you create.
如果您将来还需要维护该应用程序，那么请放弃 Access 的想法，改用 MySQL。
访问权限仅供个人使用（或者可能与少数共同用户一起使用）
If you are the one that has to maintain the application also in future then drop the idea of Access and change into MySQL.
Access is only for personal use (or maybe with some small number of co-users)
你的应用程序的用户数量并不重要，你应该使用 mysql，因为它是免费的。坚固耐用，可以处理繁忙的交通并且非常专业。它几乎拥有任何编程语言的客户端，并且互联网上有大量文档。
我希望这会有所帮助
the number of users for your app shouldnt matter, u should use mysql simply because it's free. robust, can handle heavy traffic and very professional. it has pretty much clients for any programming language and there are tons of documentation in the internet.
i hope this will help