Hello everyone,

I am working on many Access applications where I make use of the ADO Ext library in my VBA code. After sending it out an application for testing, some of the end users get a reference error for this library (even if they are running the same version of Access). The quick fix is simple, they just go into references and find the ADO Ext version that they have. It is a little irksome for end users to have to do this every time they get a new version of the application.

Does anyone know if there is a way I could distribute this library to the end users so that they will not have to make the reference change every time? I am still relatively new to Office development, and I am not really familiar with installing and importing new libraries (and have absolutely no idea how to make user created libraries). Anyways, thanks for any help.

Sounds like you need an installer app.

Also, you should have better configuration control when developing apps. If you, as the developer, have lots of cool stuff running in your app, you need to test the app on a standard desktop machine for your working environment.

I have a second workstation at my desk with a plain vanilla install for my agency, and I test all my development on it if it is going to more than a few clients. Otherwise you have to get an installer to make sure the references are there.

I looked around to try to find the registry settings for references, but didn't have much luck. Perhaps you can get a registry watcher, and then remove and replace your references and see if anything is happening in there. The references refer to .DLL files, as I understand it. But that may be wrong. Anyway, dll references are in the registry in various places.

HTH

mmcdonal

I forgot to mention, if it is a registry setting, I can give you code to make sure the settings are correct when the app launches.

mmcdonal

Thank you for the feedback. Are there any installer apps that you would recommend?