访问VBA - 相对文件引用 [英] Access VBA - relative file references

问题描述

在已经建立了几个MDA的库文件而我再从我的主要访问应用程序中引用（即使用工具 - >在IDE中引用）。

In have built a couple of mda library files which I am then referencing from my main Access application (i.e. using Tools -> References from within the IDE).

有没有一种办法，这些引用可以进行相对的而不是绝对的。我问的原因是，它会很容易地建立在用户的计算机上，如果所有三个文件（主要应用和两个MDA文件）可以简单地放置在任何目录和工作，而不必更改引用..

Is there a way that these references can be made relative rather than absolute. The reason I am asking is so that it would make it easy to set-up on the user's computer if all three files (main application and two mda files) could simply be placed in any directory and work without having to change the references...

感谢

推荐答案

为什么不直接把三个MDES在目标系统上的同一个文件夹？访问应该找到MDE参考就好了。

Why not just place the three MDEs in the same folder on the target system? Access should find the MDE references just fine.

或者，您在使用外接的逻辑与USysRegInfo表？你并不真正需要做的是用自己的加载项。只要和开发类型的加载项，如里克·费舍尔的查找和替换。

Or are you using the add-in logic with the USysRegInfo table? You don't really need to do that with your own add-ins. Just with developer type add-ins such as Rick Fisher's Find and Replace.

如果这不是为你工作，然后告诉我们什么错误信息或症状。

If this isn't working for you then tell us what error messages or symptoms.

这篇关于访问VBA - 相对文件引用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！