"hbj" wrote in message
Interesting!
After opening all the ADO libs and getting the error meg, they're all
now listed in References (even 6.1)!!! weird...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"
Peter, I use Windows 7 Enterprise 32-bit and Office 2007 Pro. At the moment
VBA requires (MISSING) "Microsoft ActiveX data Objects 6.1" located in
C:\Program Files (x86)\Common Files\System\ado. (msado15.dll) One version of
msado15.dll locates in "Program Files\..." but is that a correct dll? Which
version should I use and where can I find teh correct version?
"

It might be 6.1, though msado15.dll is also 6.0 and 2.8 as there's nothing
new in terms of public methods. Right click it, Properties, Details and look
at File version and Product version. Try removing the MISSING reference,
then browse to your msado15.dll and see if you can add it.

BTW your Win7, is that SPI? If so maybe the dll is not fully installed. If
not SPI your dll is probably 6.0. Apart from that maybe there's something in
common in your setup with what Garry described which I can't replicate.

As I mentioned before, consider coverting your project to Late Binding.

Peter T