I'm running Office 2003 (specifically Excel) on both a Windows XP 32-bit OS and Windows 7 64-bit OS. I have an excel file in which is referenced: "microsoft ado ext. 2.8 for dll and security". When run on the Windows 7 machine (from which the file was created) everything is OK. But when I try and run it on the Windows XP machine it throws an error whenever I try to use the ADO. I've noticed in the references dialog box that the above ADO's filename is different between the two machines.
Windows 7 > "C:\Program Files (x86)\Common Files\System\ado\msado28.tlb"
Windows XP > "C:\Program Files\Common Files\System\ado\msadox.tlb"
The XP machine does in fact have the "msado28.tlb" file in the ado directory and I don't know why the reference changes. Also, I have the same files in my "Program Files" directory on Win 7 as I do in the "Program Files (x86)" directory...but whenever I try to change the reference from the x86 to regular program files directory, it changes back to x86.