链接外部表 [英] Linking External Tables
问题描述
我有2台电脑：
＃1桌面 - Windows XP& Office 2000
＃2笔记本电脑 - Windows Vista& Office 2003
笔记本电脑是新的，硬盘驱动器从工厂分区为C：\和D：\，其中Vista和ProgramFiles位于C：\上，数据位于D：\
我的Access程序共享表。如果我在一台计算机上更改程序中的任何内容（前端），我不知道如何让这些计算机保持同步。
这里的问题是，如果我复制包含表单，代码，查询等的mdb文件，其他计算机上的链接无效。如果它很容易，我不介意重新连接，但它不是。要重新链接，我必须写下要链接的表名，删除链接，重新建立链接。替代是首先重新建立链接，但Access创建一个新名称（1附加到名称），所以在我删除旧链接后，我必须重命名新链接。
如果我在文件结构中移动Access程序，也会出现同样的问题。
有没有办法自动链接表？我可以将所有文件放在同一文件夹中，如果这样可以解决问题。
您是否考虑过对所有文件使用UNC名称，即使对于本地计算机上的文件也是如此？ br />
这就是我在类似情况下所做的事情。它对我来说很好。
PS。 UNC =通用命名约定（\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\我用Google搜索了一下，看到显然我不需要指定一个驱动器（它可以在任何地方）。
但是我不认为第一步是恭维。
计算机＃1（桌面）XP / Office2000
C：\ My Documents \Access programs \Xxx.mdb
C：\ My Documents \Access Programs \XXX-Tables.mdb
计算机＃2（笔记本电脑）Vista / Office2003 - 数据在D：\
Documents \Access Programs\Xxx.mdb
Documents\Access programs\XXX-Tables.mdb
我如何将这些命名为UNC？如何在Access中获取外部数据？
嘿OB;
假设你有mdb与之共享的文件夹名称MyShare，您将使用以下内容。根据您的设置，您甚至可以使用隐藏的管理共享D
I have 2 computers:
#1 Desktop - Windows XP & Office 2000
#2 Laptop - Windows Vista & Office 2003
Laptop is NEW, and the hard-drive is partitioned C:\ and D:\ from factory, with Vista and ProgramFiles on C:\ and data on D:\
My Access programs share tables. If I change anything in the program (Front-end) on one computer, I don''t know how to keep these computers in Sync.
The problem here is that if I copy the mdb file containing the forms, code, queries, etc, the links are invalid on the other computer. I wouldn''t mind re-linking if it were easy, but it isn''t. To relink, I have to write down the table names to link, delete the links, re-establish the links. Alternate is to re-establish links first, but Access creates a new name ("1" appended to name), so after I remove old links, I have to rename the new links.
This same problem occurs if I move an Access program within the file structure.
Is there some way to link tables automatically? I could put all in same folder, if that would solve problem.
Have you considered using UNC names for all files, even for those on the local computer?
This is what I do in similar circumstances & it works fine for me.
PS. UNC = Universal Naming Convention (\\ServerName\ShareName\Folder\etc).
I see where you are going here. I Googled this, and see that apparently I don''t need a drive specified (it can be anywhere).
But I don''t see step #1 to impliment.
Computer #1 (Desktop) XP/Office2000
C:\My Documents\Access Programs\Xxx.mdb
C:\My Documents\Access Programs\Xxx-Tables.mdb
Computer #2 (Laptop) Vista/Office2003 - data is on D:\
Documents\Access Programs\Xxx.mdb
Documents\Access Programs\Xxx-Tables.mdb
How do I name these to UNC? How in Access Get External Data will they show?
Hey OB;
Assuming that you have the folder that the mdb is in shared out with the name MyShare, you would use the following. Depending on your setup you might even be able to use the hidden administration share D
这篇关于链接外部表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
