Visual Studio 2008 C++ not detecting dependancy on SQLITE DLL

I have several windows C++ programs that use SQLITE via the DLL. The visual-studio projects properties refer to sqlite3.lib. They build and run OK.

However, when I create an installer, the dependency on SQLITE3.DLL is not reliably detected, the DLL is not included and my clients are plunged into "DLL Hell".

Every single time, I have to manually check that the installer has included the DLL. If it has not, then I have to manually use the "File System Editor" to add the DLL. When I do so, and request the installer to be rebuilt, visual studio suddenly detects the DLL, adds another copy of it, then complains that there are two copies. So I have to stop the build, manually remov开发者_StackOverflow社区e the extra copy, and start the built again.

here is a screenshot, showing the double copies.

alt text http://66.199.140.183/vs2008.jpg

This is very frustrating and error prone!

Is there any way to force visual studio to include exactly one copy of the DLL every time without manual intervention?

---

Are the dependency properties of "Exclude" set to "False" and "Vital" set to "True"? (Or more extremely, you might even set "Condition" to "True", which would have this component always install.)