MDA references

[Eric Benchich]

My main question is: Can you setup MDAs in the references dialog the same
way DLLs are (dynamically), so that the MDA is not tied to a specific
location?

I have an MDB application that has references to several MDA files and each
reference is hard-coded to a particular location (the same directory). I
would like to be able to install anywhere and have the MDB dynamically
reference the MDAs. Currently, the app is sent out unreferenced and code is
run to do the references manually on startup. Any ideas?

Thanks...

 

[Paul Overway]

You need to create registry entries as follows:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\RefLibPaths]
@=""
"SOMEDB.MDE"="C:\\Program Files\\SomeFolder\\SOMEDB.MDE"

Substitute 11.0 with the actual version of Access being used. Substitute
SOMEDB.MDE with the actual name of the file being referenced.

Note that if any of the MDA or MDE files is modified/recompiled, you MUST
recompile apps that have references to them. Otherwise, you'll get a nasty
error.