我有一个Access 2010数据库 A.mdb 与表的列表,其中一个是链接表,从另一个Access数据库的 B.mdb 的链接同一台服务器。这些数据库在开发计算机 xxx.xxx.xxx.xxx
,它映射在我的电脑上是 R于://
,他们后来在网上一 yyy.yyy.yyy.yyy
服务器上发布。
I have an Access 2010 database A.mdb with a list of tables, one of which is a linked table, linked from another Access database B.mdb on the same server. These databases are on a development machine xxx.xxx.xxx.xxx
, which is mapped on my computer as R://
, and they are afterwards published online on a yyy.yyy.yyy.yyy
server.
如果我想在数据库上本地工作,我需要改变的链接表。但是,如果我通过文件系统来修改它(使用链接表管理器),该链路变成 R:// ....
键,当我在看的ASP页要求这些数据,它被打破,因为路径是错误的。此外,如果我局部改变的链路,也不会在在线服务器上工作。
If I want to work on the database locally, I need to change the link to the table. But if I change it via filesystem (using the "Linked Table Manager"), the link becomes R://....
and when I look at the ASP page that requests those data, it is broken because the path is wrong. Also, if I change the link locally, it won't work on the online server.
有没有办法更改链接编程?也就是说,在不使用链接表管理器?
Is there a way to change the link "programmatically"? That is, without using the Linked Table Manager?
我寻找一个答案,但我不是专家,我只知道,我必须写一个模块? 宏?
I searched for an answer, but I am not that expert, I just understood that I have to write a "Module"? "Macro"?
推荐答案
表链接即可UNC路径。例如,假设我有一个链接表指向数据库 192.168.1.2 公用
被映射到驱动器点:
。如果我启动VBA编辑器(替代 + F11 ),打开立即窗口(控制 +
相关推荐
最新文章