Acc2003 + OWC11 = ?Huh?

[Mark Burns]

OK, I have an Access2003-format .MDB open in Access 2003.
The references are set so that OWC11.dll is referenced, and OWC10.dll is NOT
referenced.
OWC11.dll is the Office Web Components for Office 2003.
OWC10.dll is the Office XP Web Components.

Create a form, open it in pivottable view (doesn't matter if the form's
pivottabel has been set up or not)

Form_Open()
dim oPT as OWC11.PivotTable

set oPT = me.PivotTable <== *Thud* with a VBA Type Error (5). ???

End Sub

If you replace the OWC11.PivotTabvle with OWC10.PivotTable (*after including
the appropriate OWC10.dll reference in the VBA References list *), the above
code just runs. . . . ...????!!!

OK...<NOT!>
*WHY* is Access *2003* returning an Office XP Web Components (OWC10)
PivotTable Object regardless of which version of the Office Web Components is
referenced??

....and how the heck are we supposed to distribute .mdb databases for use
possibly on computers that have never had Office XP installed (and presumably
thus won't have the OWC10.dll on the machine)??? (and don't tell me I need to
create an installer!)

 

[Mark Burns]

Answer:
Hidden in an obscure MSDN Kb Article:
http://support.microsoft.com/kb/828408/en-us

"This problem occurs because Access 2003
does not support Office 2003 Web Components."
?huh? - ok, but it's all ok, because:
"Access 2003 uses Microsoft Office XP Web Components.
Office XP Web Components are installed
as part of Microsoft Office 2003."

....nice of them to let us know so conveniently.

 

[HKComputer]

My Office XP Developer DOES package this file when you create an
installer with the Packaging wizard. I didn't read the above Microsoft
article, but you may need to consider an installer.