后端错误 [英] Back End error

问题描述

大家好，


我有3个数据库和一个后端数据库。 3个数据库是前端文件，用户将输入数据并使用表单/查询等。所有这些表都与后端数据库链接，后端数据库仅包含表格，这似乎是从我的研究中做到这一点的正确方法。


但是，当用户试图运行数据库时，他们会收到有关BackEnd db无法找到的错误。



有什么可能的解决方案？


谢谢。

Hello all,

I have 3 databases and a backend database. The 3 databases are front end files which users will be entering data and using forms/queries etc. All of these tables are linked with the backend database which consists of only the tables, which appears to be the correct way to do it from my research.

However, when users are attempting to run the databases, they are getting an error regarding the BackEnd db "could not be found."


What are possible solutions for this?

Thanks.

推荐答案

在链表中管理器检查是否列出了后端数据库表的正确路径，并使用完整的UNC路径而不是映射的驱动器。数据库的所有用户可能没有完全相同的驱动器映射。如果您已完成此步骤并仍然收到相同的错误消息，请检查以确保后端数据库正确打开。后端可能已损坏且无法打开。

In the linked table manager check that the correct path for the back end database tables is listed and use the full UNC path as opposed to a mapped drive. All users of your database may not have exactly the same drive mapping. If you''ve already done this step and still get the same error message, check to make sure that the back end database opens properly. It is possible the back end is corrupt and won''t open.

感谢您的回复。我已经筋疲力尽了我想到的每一个选择（我不是专家）。我可以按原样打开数据库，它们对我来说都很好，但不适合特定的人群。我制作了后端的副本并将其放在他们的文件夹中，但是它正在工作，但这会破坏数据库的目的，因为所有记录都需要在1个后端数据库中。


我已刷新链接表管理器中的文件路径。仍然收到相同的错误。我的意思是，如果它适用于我和少数其他用户，我不知道后端是如何腐败的。


让我知道你的想法。谢谢。

Thanks for your response. I''ve exhausted every option that comes to my mind (I am no expert). I can open the databases as is and they all work fine for me, however not for a specific group of people. I made a copy of the backend and placed it in their folder, and it was working, however that defeats the purpose of the database, as all of the records need to be in 1 backend database.

I''ve refreshed the file paths in the linked table manager. Still receiving the same error. I mean I don''t see how the backend could be corrupt if it works for me and a handful of other users.

Let me know what you think. Thanks.

您正在为所有数据库用户使用完整的UNC路径？是否可能是驱动器映射问题？如果您使用映射驱动器作为链接表管理器中的路径并且某些用户具有不同的驱动器映射，则可能是这种情况。

You''re using the full UNC path for all db users? Is it possible that it is a drive mapping issue? This could be the case if you use a mapped drive as the path in the linked table manager and some users have different drive mappings.

这篇关于后端错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！