database 网络访问中断

Network access was interrupted

提问by Magnus

The Access database just needs to be open and it will usually crash within the next 20-40mins, resulting in the following error message:

Access 数据库只需要打开，它通常会在接下来的 20-40 分钟内崩溃，导致以下错误消息：

Your network access was interrupted. To continue, close the database, and then open it again.

More details:

更多细节：

• The database is split, with the back end and front end on a server. The computers are then connected to the server via LAN (ethernet).
• Although there are multiple computers connected to the server, the database only has one user at a time.
• The database has been fine for almost a year, until this week where this error has started occurring.
• We never have connectivity issues with the server.

• 数据库是拆分的，后端和前端在一个服务器上。然后计算机通过 LAN（以太网）连接到服务器。
• 虽然有多台计算机连接到服务器，但数据库一次只有一个用户。
• 数据库已经运行了将近一年，直到本周开始出现此错误。
• 我们从来没有与服务器的连接问题。

I have seen several answers saying it is:

我看到几个答案说它是：

• the databases fault, as it is starting to corrupt
• the servers fault, as it broken, dropping my connection briefly
• microsofts fault, they should patch it

• 数据库故障，因为它开始损坏
• 服务器故障，因为它坏了，短暂地断开了我的连接
• 微软的错，他们应该修补它

I am hoping this is a problem with the database itself, as I am not responsible for the server.

我希望这是数据库本身的问题，因为我不对服务器负责。

Does anyone have a definitive solution?

有没有人有明确的解决方案？

采纳答案by Sorcefyre

The problem sounds like an unstable LAN connection OR changes the LAN location (e.g. new hardware or changs to admin settings) causing increased latency.

问题听起来像是不稳定的 LAN 连接或更改 LAN 位置（例如新硬件或更改管理设置）导致延迟增加。

If you have forms in the FE bound to BE tables the latency can cause the connection to be severed resulting in the error you see.

如果 FE 中的表单绑定到 BE 表，则延迟可能会导致连接被切断，从而导致您看到的错误。

I'm not a network admin but the main culprits I've seen are:

我不是网络管理员，但我见过的罪魁祸首是：

• Users connecting to the network using a VPN using an unstable connection (cell phones, crappy wifi, or just bad ISP service).
• Network admins capping persistent connections to a share causing disconnects.
• Unstable network hardware or bad hardware configuration.
• "Switching" between wired and wireless LAN connections.

• 用户使用 VPN 使用不稳定的连接（手机、糟糕的 wifi 或糟糕的 ISP 服务）连接到网络。
• 网络管理员限制对共享的持久连接导致断开连接。
• 网络硬件不稳定或硬件配置错误。
• 在有线和无线 LAN 连接之间“切换”。

I don't think the issue is the database other than having bound forms to a BE database which is more of a fundemental design problem than anything else.

除了将表单绑定到 BE 数据库之外，我认为问题不在于数据库，这更像是一个基本设计问题。

Good luck!

祝你好运！

回答by pranananda

I have recently experienced the same problem, and it all started when I moved my DB in an extrernal disk. The same db was working just fine in the local disk, or in the previous external disk. So, i am guessing is just a bug that has to do with the disk letter changing or something like this.

我最近遇到了同样的问题，这一切都是在我将数据库移动到外部磁盘时开始的。相同的数据库在本地磁盘或以前的外部磁盘中工作得很好。所以，我猜这只是一个与磁盘字母更改或类似问题有关的错误。

回答by Rex

You wrote, "The database has been fine for almost a year, until this week where this error has started occurring."

您写道：“数据库已经运行了将近一年，直到本周开始出现此错误。”

Clearly something has recently changed for this to be happening and without narrowing the field of possibilities it's anyone's guess. However, in my experience Jet DB crashes when two or more users are accessing and editing the same record(s) at the same time. So, if you've recently added new users this is a possibility.

显然，最近发生了一些变化，这正在发生，而且没有缩小可能性的范围，这是任何人的猜测。但是，根据我的经验，当两个或多个用户同时访问和编辑相同的记录时，Jet DB 会崩溃。因此，如果您最近添加了新用户，这是可能的。

Note: Jet is a file-server DB not a client server, which means the app was probably designed for a specific number of front-end users. Without knowing more I would start there.

注意：Jet 是一个文件服务器数据库，而不是客户端服务器，这意味着该应用程序可能是为特定数量的前端用户设计的。在不知道更多的情况下，我会从那里开始。

回答by Robert Saunders

I resolved my issue on this when I figured out that I had a offline directory setup and the sync was having an issue I turned off the sync and tested it and the error went away.

当我发现我有一个离线目录设置并且同步出现问题时，我解决了我的问题，我关闭了同步并对其进行了测试，错误消失了。

回答by Lekiwonder

I use Access 2010. I had the same issue but solved it in the following ways.

我使用 Access 2010。我遇到了同样的问题，但通过以下方式解决了它。

1. On the external data ribbon, go to the Import & link group and click on Linked Table Manager.

2. Click on select all.

3. Click on Ok to refresh the links.

1. 在外部数据功能区上，转到导入和链接组，然后单击链接表管理器。

2. 点击全选。

3. 单击“确定”刷新链接。

In cases where the path of the BackEnd database file has been changed, browse to the new location and select the new path. This will also refresh the links. This will solve the problem. It did for me.

如果后端数据库文件的路径已更改，请浏览到新位置并选择新路径。这也将刷新链接。这将解决问题。它对我有用。