Thanks to dglienna. it really is a very informative post. But by doing that I would have to change the entire structure of my coding. So I' keeping that as a last resort. Thank you very, very much. at least I have a plan B

To WoF sorry. I was kinda confused DAO with ADO. I put a reference for DAO actually. Truly sorry for confusing you. Do you know why I'm having this problem? Any help would be greatly appreciated