FrontEnd BackEnd链接 [英] FrontEnd BackEnd linking

问题描述

在那里，我目前有一个前端后端设置。我正在寻找的是我可以在前端的启动表单中使用的一段简洁代码，它告诉它后端位于。这是可能的。

解决方案

您好，我目前有一个前端后端设置。我正在寻找的是我可以在前端的启动表单中使用的一段简洁代码，它告诉它后端位于。那可能吗。

此代码在我目前使用的实时数据库上进行了测试。以下代码将生成所有链接表和它们链接的后端数据库的列表。有任何疑问，请随时询问：

展开 | 选择 | Wrap | 行号

这不是用于列出您的链接，而是用于生成新链接BE被移动。



这是我使用的，我发现并组合和修改的。我在一个特殊的重新链接表单和一个未绑定的文本框上创建一个按钮，您可以在其中键入BE所在的整个路径和文件名（通过键入带扩展名的文件名，您可以使用任何版本的Access - 即2007 - 我将其重新设置为参与代码寻找文件名并寻找特定的扩展名。


我手动输入它而不是使用MS库来选择目录，因为有些计算机没有合适的DLL来使用MS库。


这里有一些额外的东西但是没有被激活所以不用担心它。


你只需要在每个上运行一次计算机，如果BE安装或移动到原始版本的不同目录中。如果您将驱动器号映射到服务器/目录，也可以在网络上工作。


由于原作者明确的版权声明声明而删除的代码 Dev Ashish 除了作为申请的一部分之外不应该分发

hi在那里，我目前有一个前端后端设置。我正在寻找的是我可以在前端的启动表单中使用的一段简洁代码，它告诉它后端位于。那可能吗。

这不是用于列出您的链接，而是用于在移动BE时生成新链接。


这是我使用的，我发现并组合和修改的。我在一个特殊的重新链接表单和一个未绑定的文本框上创建一个按钮，您可以在其中键入BE所在的整个路径和文件名（通过键入带扩展名的文件名，您可以使用任何版本的Access - 即2007 - 我将其重新设置为参与代码寻找文件名并寻找特定的扩展名。


我手动输入它而不是使用MS库来选择目录，因为有些计算机没有合适的DLL来使用MS库。


这里有一些额外的东西但是没有被激活所以不用担心它。


你只需要在每个上运行一次计算机，如果BE安装或移动到原始版本的不同目录中。如果您将驱动器号映射到服务器/目录，也可以在网络上工作。


由于原作者明确的版权声明声明而删除的代码 Dev Ashish 除非作为申请的一部分，否则不应该分发

订阅仅供参考

hi there, i currently have a Front end Back end setup. What i am looking for i a neat piece of code i can use on the Start up form in the Front end, that tells it were the Back end is located. Is that possible.

解决方案

hi there, i currently have a Front end Back end setup. What i am looking for i a neat piece of code i can use on the Start up form in the Front end, that tells it were the Back end is located. Is that possible.

This code was tested on a ''live'' Database that I currently use. The following code will generate a listing of all ''Linked'' Tables and the Back End Database to which they are linked. Any questions, feel free to ask:

Expand|Select|Wrap|Line Numbers

This is not for listing your links but to generate a new link if the BE is moved.


This is one I use that I found and combined and modified. I create a button on a special relink form and an unbound text box where you type the whole path and file name where the BE is (by typing the file name with extension you can use any version of Access - ie 2007 - i remmed out the part in the code that was looking for the file name and looking for specific extensions).

I type it in manually instead of using the MS library for picking a directory because some computers don''t have the proper DLL to use the MS library.

There is some extra stuff in here but won''t get activated so don''t worry about it.

You only need to run it once on each computer if the BE is installed or moved in a different directory of your original build. Also works on a network if you map a drive letter to a server/directory.


Code Removed due to explicit copyright declaration claim by original author Dev Ashish that it should NOT be DISTRIBUTED EXCEPT as part of an application

hi there, i currently have a Front end Back end setup. What i am looking for i a neat piece of code i can use on the Start up form in the Front end, that tells it were the Back end is located. Is that possible.

This is not for listing your links but to generate a new link if the BE is moved.


This is one I use that I found and combined and modified. I create a button on a special relink form and an unbound text box where you type the whole path and file name where the BE is (by typing the file name with extension you can use any version of Access - ie 2007 - i remmed out the part in the code that was looking for the file name and looking for specific extensions).

I type it in manually instead of using the MS library for picking a directory because some computers don''t have the proper DLL to use the MS library.

There is some extra stuff in here but won''t get activated so don''t worry about it.

You only need to run it once on each computer if the BE is installed or moved in a different directory of your original build. Also works on a network if you map a drive letter to a server/directory.


Code Removed due to explicit copyright declaration claim by original author Dev Ashish that it should NOT be DISTRIBUTED EXCEPT as part of an application

Subscribing for information purposes only

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