MS Access 数据库
我试图找到一个编码不良的 vb.NET 应用程序（在 Vista 上运行，数据库在 Win Server 2K3 上）的问题，该应用程序在使用时似乎随机冻结和崩溃。最常见的情况是同时由多个用户使用（最多 2 到 5 个用户）。该程序没有后端服务器，客户端只需连接到 MS Access 2k 数据库并执行其操作。该程序已经成功运行了 3 年多（不知何故），工作量很大，而且问题似乎是最近才出现的。我相当确定问题出在 Access 数据库上，但在查找有关 MS Access 如何处理同时读/写的详细信息时遇到了问题（访问是通过 vb.NET 库进行的）。 Access 是否有内置协议来处理这个问题？有谁知道为什么三年后工作量较轻时会出现这个问题吗？
注意：我无权访问源代码
已安装标准 Windows 更新，并且未应用新的访问更新
I am attempting to find a problem with a poorly coded vb.NET application (running on vista with database on Win Server 2K3) that randomly seems to freeze and crash when in use. Most frequently this is when used by more than one user at at time (2 to 5 users max). This program has no back end server, the clients just connect to an MS Access 2k database and do their thing. This program has been running successfully for over 3 years (somehow) with a heavy workload, and the problem seems to be recent. I am reasonably certain the issue is with the access database, but I am running into problems finding details on how MS Access handles simultaneous read/writes (access is via vb.NET library). Does access have built in protocol to handle this? Does anyone have any ideas why the problem would emerge after 3 years, and with a lighter workload?
Note: I do not have access to source code
Standard windows updates have been installed, and no new access updates have been applied
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看看这篇文章。这是我见过的对 Access 并发问题最清晰的解释。
msaccess-mdb-concurrency
Have a look at this post. Its the clearest explanation of Access concurrency issues I have seen.
msaccess-mdb-concurrency