Missing: MS ActiveX Data Objects (multi-dim) 6.0 Library

[DianeA]

I have an excel 2003 SP3 spreadsheet which has a script that dumps data into Access 2003. This has been working great until the other day and now we get an error which when I go to references I see "Missing: MS ActiveX Data Objects (Multi-Diminentional) 6.0 Library" . I uncheck this and everything works til the next day and then this statement is back in references.

This 6.0 library is not in the references for me to check. We are on XP machines. This user recently worked on this spreadsheet on his new laptop Vista home machine.

Could something have got changed when he opened it within Vista? He is running Excel / Access 2003 from home as well.



Diane

 

[Chance1234]

possibly

Use late binding instead of early binding thought to avoid this.

Chance,

F, G + yeah reached 50

 

[DianeA]

And / Where how do I change this?

Diane