I have multiple access databases, and some require certain reference libraries and others do not. It seems when I add or remove a ref libraries, it's a global setting and the next time I open a database, the libraries available are the ones that were included when I last closed access. This makes it difficult when developing or deploying different apps.

1. is there a way to dynamically load only the libraries needed when an Access app is opened?

2. When invoking functions, methods, or objects, how do you know which library is needed (so you can tell which other loaded libraries are possibly not needed)? For instance, if I want to use a tree object, how would I know to include the MS ActiveX Data Objects 2.7 library?

Sorry for the long questions, but any help is appreciated.