Here's an idea I did not see in your post. Did you set a reference
to the ADO library using the reference command in the VBE?
Select Tools > References. Find the Microsoft ActiveX Data Objects
with the highest version number. I use Microsoft ActiveX Data
Objects 2.8 Library.