Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Relative file references

Tags:

vba

ms-access

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).

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...

Thanks

like image 277
MT. Avatar asked Sep 07 '09 14:09

MT.


People also ask

What is a relative file path?

A relative path refers to a location that is relative to a current directory. Relative paths make use of two special symbols, a dot (.) and a double-dot (..), which translate into the current directory and the parent directory. Double dots are used for moving up in the hierarchy.

What is an example of relative path?

A relative path needs to be combined with another path in order to access a file. For example, joe/foo is a relative path.

What is a relative file name?

A file name can specify all the directory names starting from the root of the tree; then it is called an absolute file name. Or it can specify the position of the file in the tree relative to a default directory; then it is called a relative file name.


1 Answers

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

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.

like image 162
Tony Toews Avatar answered Sep 29 '22 07:09

Tony Toews