Object Library 9.0 needs to be 10.0

[David]

I have my work computer with Access 2002 that references
Object Library 10.0. My home computer with Access 2000
references Object Library 9.0. This has an impact when I
am trying to Output a query to an excel file. Here is
the line of code that works in 2002, but not in 2000.

DoCmd.OutputTo acQuery, "Main Table Query for
Date", "MicrosoftExcelBiff8(*.xls)", "", True, "", 0

the acQuery seems to be the reference causing the issue.

How can I update or add Object Library 10.0 to my Access
2000?

Any assistance would be greatly appreciated.

David

 

[Douglas J. Steele]

You can't. Access 2000 will not work with Object Library 10.0 (It's also not
legal to copy the library to another machine)

Try using the TransferSpreadsheet method rather than OutputTo.