同时链接多个表 [英] Linking Multiple Tables Simultaneously

问题描述

大家好

我希望更改我公司的文档控件Access db。

为了让我的想法得到解决已将当前的前端和后端文件复制到本地文件夹中。  这些已重命名以避免任何混淆。  所以现在我想将链接从实时后端重定向到我的本地副本。  我已启动
链接表管理器，勾选"始终提示新位置"复选框 并选择当前后端文件中的所有表。

问题是，当您启动前端时，您需要指定每个后端表的位置，甚至虽然它们都在同一个mdb后端（bar one）中。  由于有很多表，无论如何都要快捷这个操作？
 我对进入代码不感兴趣，但如果我错过了一个简单的解决方案，那将非常有用。

谢谢

Phil

解决方案

你好菲尔，

我认为没有VBA没有快速方法。 

我建议你访问  自动重新链接Microsoft Access表，在本文中，我们将向您展示如何调用单个表使用
小代码自动重新链接后端表的过程，即使数据库文件已移动到其他文件夹也是如此。该过程还将重新链接多个后端中的表。最重要的是，你不必太多知道如何编写代码来
使这项工作。

问候，

Celeste

Hi all

I am looking to make changes to my company's document control Access db.

To get my thoughts straight I have copied the current front and backend files into a local folder.  These have been renamed to avoid any confusion.  So now I want to redirect the links from the live backend to my local copy.  I have initiated the Link Table Manager, ticked the "Always prompt for new location" checkbox  and selected all the tables in the current backend file.

The trouble is, when you then launch the front end, you are expected to specify the location of every backend table, even though they are all (bar one) in the same mdb backend.  As there are lots of tables, is there anyway to shortcut this operation?  I'm not interested in going into code, but if I am missing an easy work around that would be useful.

Thanks

Phil

解决方案

Hello Phil,

I think there is no quick method without VBA. 

I suggest you visit Automatically relink Microsoft Access tables, in this article we will show you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. The procedure will also relink the tables in multiple back-ends. And best of all, you don’t have to know much about writing code to make this work.

Regards,

Celeste

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