ADO references changing incorrectly

[JakeTheSnake3.0]

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.

 

[JakeTheSnake3.0]

I'm guessing it has something to do with this, but I already have SP1 and the problem persists.

 

[RoryA]

What error do you get specifically? ADOX is not the same as the ADO library.
That MSKB article refers to Office 2010 64bit and is not applicable to Office 2003 which does not have a 64bit version.

 

[JakeTheSnake3.0]

The error was "430" "class does not support automation". I have just now tried to disable the specific resource I mentioned; the program seems to be working without it so at least I have that to go on (I was executing ADODB connections with an access database). I'm still perplexed at to why this happened in the 1st place.