I’ve just come across a new COM wrapper for SQLite from German company Datenhaus (like the name, maybe I should call myself Datenschmidt?). I’ve started to use the COM free PSSQLITE.DLL in my Excel VBA projects but I may consider using the Datenhaus dhSQLite library in certain situations as it includes a database encryption option and it also is capable of being used without registration by using it along side DirectCOM, another tool from the same company. In fact DirectCOM allows for the registration-free deployment of any COM library, could be very useful in these days of locked-down corporate desktops.
Both tools are free but closed-source (but they’re open to offers if anybody wishes to purchase the code!). Also, no details on what the dhSQLite encryption methods are, so maybe not suitable for very sensitive data (always a problem with closed-source products that offer encryption).