如何更改Access Office 16中链接表的路径 [英] How to change the path of linked tables in Access office 16

问题描述

嗨专家，

我需要更改链接的Manger表中显示的链接表的位置。任何人都可以帮我这个。这是一项紧急要求

I need to change the Location of the linked table shown in the linked Manger table. Can anyone help me on this one. Its an urgent requirement

我正在办公室16

问候

Anna

推荐答案

打开链接表管理器（外部工具 - >链接表管理器）

Open the Linked Table Manager (External Tools -> Linked Table Manager)

对话框打开后，选中"始终提示新位置"; （左下角）

When the dialog opens, Check the "Always prompt for new location" (bottom left hand corner)

点击"全选"按钮（右侧）

Click the "Select All" button (right hand side)

单击"确定"按钮按钮

使用文件对话框查找要重新链接表的BE（尽可能使用网络/ UNC而不是映射驱动器）

Use the file dialog to go and find the BE to relink the table from (use network/UNC instead of mapped drives as much as possible)

点击"打开"按钮按钮

等到您收到"所有选定的链接表格已成功刷新"

Wait until you get the "All selected linked tables were successfully refreshed"

点击"确定"按钮按钮

点击"关闭"按钮按钮

现在是执行压缩和修复的好时机

Now is a good time to perform a Compact and Repair

这篇关于如何更改Access Office 16中链接表的路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！