dotnet interop: I wrote an app that transferred data from Excel to Access (Office 2000 on XP
Professional).
I had it in release form and it was working fine. I installed PIA's to
develop another
App and now I get an error on the first App informing me of an unhandled
Exception of the
type "System.InvalidCastException" in the line where the Excel application
is created.


I've deleted the PIA's according to MS's instructions however I'm still
getting the error.
I need to somehow correct the system so it can run the first App. Is there
something
else that the PIA install program does? Once PIA's are installed, is Visual
Studio prevented
from creating interop assemblies for Office 2000?

[quoted text, click to view]

===========================================

Was "first app" using the Office XP PIAs? If it was, why would you
(re)install the Microsoft's PIAs for "second app"? Or did you uninstall the
XP PIAs and install the Office 2003 PIAs for "second app"?

What MS instructions for deleting the PIAs were you using? If the PIAs were
"uninstalled", did you verify that they no longer exist in the GAC? If they
were really uninstalled, NEITHER app should work because the assemblies
couldn't be found.

The PIAs ARE the relevant Interop assembly in this case. Why are you asking
if "VS.Net is prevented from creating interop assemblies..." when you should
be using (and your project should be referencing) the MS PIAs in the GAC?


Try using fuslogvw.exe (or debugging) to determine the location that the PIA
is loaded from - if you uninstalled, it shouldn't BE loaded, and if it IS
loaded, fuslogvw will give you the info on location and version.