Access表如何在启动时链接

本文介绍了Access表如何在启动时链接的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有一个复杂的链接问题。在我了解详细信息之前，

我想知道Access在启动时如何链接到后端文件，之后我已经分配了我的应用程序
给客户。

这就是问题所在。当我正在处理我的应用程序时，我与我的计算机上的后端相关联。当我分发应用程序时，后端文件显然位于

不同的位置（在客户端服务器上）。

但是我的应用程序第一次启动时在客户端位置，后端的

连接字符串仍然是我的开发计算机

，这些字符串显然无效。

现在我有一个自定义链接例程并使用启动器。启动器通过Command传递

到我的应用程序，后端文件的正确位置。在过去的6个月里，这已经完美无缺地工作了，但是最近对客户的更新

无法正常工作并产生链接错误。但是，我遇到了麻烦

复制问题。

所以，现在，我只想知道Access遇到什么时会做什么

我提到的情况。仅当代码或某些操作

尝试从无效的表链接中提取数据时才会生成错误。换句话说，

Access将允许启动时无效的连接字符串，并且仅在采取某些操作实际查看或选择来自

>
链表。我应该提一下，我也使用RWOP查询，所以我想知道为什么在

RWOP查询时启动时没有产生错误的原因从链接表中选择数据。我想这肯定意味着

它实际上并没有选择直到某种类型的动作被采取（即

用户打开RWOP查询或代码尝试执行关于查询的动作）。

了解这是如何工作的，我认为这将有助于我解决我的问题。

谢谢。

-

通过

I''m having a complicated linking problem. Before I get into the particulars,
I''d like to know how Access links to the back-end file at startup, AFTER I''ve
distributed my application to the client.

Here''s the issue. While I''m working on my app, I''m linked to the backend on
my computer. When I distribute the app, the backend file is obviously in a
different location (on the client server).

But the first time my app is started up at the client location, the
connection strings for the backend will still be to my development computer
and these strings are obviously invalid.

Now I have a custom linking routine and use a launcher. The launcher passes
to my app via Command, the correct location of the backend files. This has
worked flawlessly over the past 6 months, but a recent update to the client
failed to work and generated a linking error. But, I''m having trouble
replicating the problem.

So, for now, I would just like to know what Access does when it encounters
the situation I mentioned. Is an error generated only if code or some action
attempts to extract data from a table link that is not valid. In other words,
Access will allow the invalid connection strings on startup and an error is
only generated when some action is taken to actually view or select data from
the linked table. I should mention that I use RWOP queries as well, so I
guess I''m wondering why there isn''t an error generated at startup when the
RWOP query selects data from the linked table. I guess this must mean that
it doesn''t actually select until an action of some type is taken (i.e. the
user opens the RWOP query or code tries to perform an action on the query).

Understanding how this works, I think will help me in solving my problem.

Thanks.

--
Message posted via http://www.accessmonster.com

Startup

Access表如何在启动时链接

问题描述

推荐答案