查看或刷新链接
使用以下过程查看或刷新结构时的链接或
链接表的位置已更改.链接表管理器列表
所有当前链接表的路径.
Use this procedure to view or to refresh links when the structure or
location of a linked table has changed. The Linked Table Manager lists
the paths to all currently linked tables.
- 打开包含表链接的数据库.
- 在工具"菜单上,
指向数据库实用程序,然后单击链接表管理器.
- 选中要刷新其链接的表的复选框.
- 单击确定"刷新链接.
- Open the database that contains links to tables.
- On the Tools menu,
point to Database Utilities, and then click Linked Table Manager.
- Select the check box for the tables whose links you want to refresh.
- Click OK to refresh the links.
Microsoft Access确认成功
刷新,或者,如果找不到该表,则显示选择新的"
对话框的位置,您可以在其中指定
表格的新位置.如果几个选定的表已移至新表
您指定的位置,链接表管理器搜索
所有选定表格的位置,并一步更新所有链接.
Microsoft Access confirms a successful
refresh or, if the table wasn't found, displays the Select New
Location of dialog box in which you can specify the
table's new location. If several selected tables have moved to the new
location that you specify, the Linked Table Manager searches that
location for all selected tables, and updates all links in one step.
要更改一组链接表的路径
- 打开包含表链接的数据库.
- 在工具"菜单上,
指向数据库实用程序,然后单击链接表管理器.
- 选中始终提示输入新位置复选框.
- 选择支票
框,单击要更改其链接的表,然后单击确定".
- 在选择新位置"对话框中,指定新
位置,单击打开",然后单击确定".
- Open the database that contains links to tables.
- On the Tools menu,
point to Database Utilities, and then click Linked Table Manager.
- Select the Always prompt for new location check box.
- Select the check
box for the tables whose links you want to change, and then click OK.
- In the Select New Location of dialog box, specify the new
location, click Open, and then click OK.
这篇关于需要使用链接表更改MS Access中的sql server数据库名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!