Access not working since Visio 2000

[Kirsten]

One of our users has Win XP Pro with Office XP Pro. He
upgraded from Visio Standard 5 to Visio 2000 today and
since doing so has had problems with his Office suite.
When he tries to open Excel he gets the warning "Compile
error in hidden module: this workbook". He can OK this
message and use Excel but Access does not work at all (no
messages). Outlook and Word seem to be fine so it seems
to be a problem with VBA.

I have trawled through the MS knowledge base and cannot
find a match for this issue. A lot of similar things but
the fixes for those did not work either.
I can find a KB article on the opposite of this problem -
Visio 2000 stops working when upgrade Office to XP, but
can find nothing on Office XP stops working when Visio
upgraded to 2000.
Another user upgraded to Visio 2000 and has had no
problems but he uses Office 2000.

The user that is using Office XP has tried removing &
reinstalling office. Then tried the same with Visio.
Then removed both office and visio, reinstalled visio
first (in case it removes something from Office) then
installed office. None of these actions worked.

Does anyone know what causes this? Perhaps you know of a
KB article on the matter that I did not find? Or can you
suggest a service pack for OfficeXP/Visio2000?

Thanks,
Kirsten

 

[Sandra Daigle]

Hi Kirsten,

It is generally recommended to install Office programs in version order
(earliest to most recent). I suspect that when you installed Visio 2000, it
clobbered the VBA dll. Running detect and Repair from one of the office
programs might solve the problem - other wise you might need to uninstall
OfficeXP, then reinstall it over Visio 2000.

OFFXP: Running Multiple Versions of Microsoft Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;290576