In the VBE , (that's the place that you write your code), go to the
menu bar and select: Tools | References.
In the drop down list, find and checkmark the library name.
I have several versions of the ...Data Objects library listed.
It's probably best to checkmark the latest version.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"Duke17" wrote in message
Jim, thanks for directing me to that link, it's been very helpful.
There's one thing I'm having trouble with, though. I need to "set a
reference to the Microsoft ActiveX Data Objects 2.5 library in the VBA
editor." I'm not sure how to do this...can you please help?
Thanks!
--
Duke17