I have looked in to this problem and I no longer think it is associated with the VBA Editor, but for future reference here is how use it.
Press Alt + F11 to open the VBA Editor.
On the main Menu at the top there should be Tools, it is usually about 7th from the left.
Click Tools and the first item should be References, this is a list of the sub programs that VBA can use and the top ones that are ticked are the ones in use.
When you want to manipulate a program like Excel you need to go down the list to MS Excel and tick it, or Word or Outlook etc.

Your problem appears to be caused by a conflict between 32 bit and 64 bit versions of Access or Office. see
https://social.msdn.microsoft.com/Fo...tdataproviders